Labels automatically resizing in form design - Access 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-1549826%22%20slang%3D%22en-US%22%3ELabels%20automatically%20resizing%20in%20form%20design%20-%20Access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549826%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20it%20is%20just%20me%20not%20seeing%20a%20setting%20somewhere.%20In%20previous%20versions%20I%20cannot%20remember%20this%20happening%20but%20it%20is%20rather%20annoying.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20in%20design%20mode%20of%20a%20form%2C%20if%20I%20change%20the%20text%20in%20a%20label%2C%20the%20label%20automatically%20resizes.%20Is%20there%20a%20global%20setting%20to%20turn%20this%20off%3F%20This%20is%20only%20relevant%20AFAIK%20to%20Access%202019%2C%20I%20use%202016%20on%20desktop%20when%20in%20the%20office%20or%20using%20company%20laptop%20and%20do%20not%20have%20this%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20my%20use%20is%20within%20a%20suite%20of%20database%20front%20ends%20I%20have%20developed%2C%20they%20all%20have%20the%20same%20type%20of%20form%20design%20so%20I%20can%20copy%20a%20form%20which%20does%20a%20similar%20function%20from%20one%20of%20the%20databases%20when%20building%20a%20new%20one%20to%20add%20into%20the%20suite.%20All%20my%20labels%20are%20nicely%20sized%20so%20everything%20is%20uniform%2C%20but%20when%20I%20type%20a%20different%20text%20into%20the%20label%20(e.g.%20change%20from%20Order%20Number%20to%20Employee%20Name)%20the%20label%20resizes%20itself%20and%20I%20have%20to%20then%20resize%20the%20label%20again%20so%20that%20it%20fulfils%20the%20requirement%20of%20my%20OCD.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdded%20a%20couple%20of%20example%20images.%20In%20image%201%20I%20have%20taken%20a%20form%20which%20is%20used%20to%20add%20employee%20skills%2C%20made%20a%20copy%20and%20now%20changing%20this%20to%20add%20in%20an%20absence.%20Changing%20the%20label%20text%20automatically%20resized%20the%20label%20meaning%20I%20have%20to%20then%20go%20manually%20resize%20it%20to%20what%20it%20was%20previously.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20is%20enough%20info.%20Sensible%20answers%20only%20please.%20I%20could%20write%20VBA%20or%20use%20Access%202016.%20I%20only%20require%20a%20response%20if%20there%20is%20a%20way%20to%20do%20this%20or%20not%2C%20and%20if%20possible%20how%20to%20prevent%20it%20from%20happening.%20Thanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1549826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForm%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForm%20Design%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553754%22%20slang%3D%22en-US%22%3ERe%3A%20Labels%20automatically%20resizing%20in%20form%20design%20-%20Access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553754%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20editing%20through%20the%20label%20control%20itself%20or%20by%20changing%20the%20caption%20property%20in%20the%20Property%20Sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554430%22%20slang%3D%22en-US%22%3ERe%3A%20Labels%20automatically%20resizing%20in%20form%20design%20-%20Access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459380%22%20target%3D%22_blank%22%3E%40Daniel_Pineault%3C%2FA%3E%26nbsp%3BI%20was%20editing%20directly%20in%20the%20label%2C%20but%20changing%20the%20caption%20property%20in%20the%20property%20sheet%20does%20prevent%20it%20from%20resizing%20which%20solves%20my%20issue.%20I%20can%20now%20just%20change%20the%20label%20caption%20there%20to%20avoid%20all%20the%20extra%20actions.%20I%20am%20sure%20in%2013%20and%2016%20I%20changed%20within%20the%20label%20and%20it%20didn't%20resize%20so%20will%20check%20that%20again%20tomorrow%20just%20for%20my%20own%20sanity%2C%20though%20I%20tend%20to%20just%20go%20on%20autopilot%20once%20I%20start%20working%20in%20Access.%20Thanks%20for%20your%20help%2C%20I%20knew%20it%20would%20be%20something%20simple!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555036%22%20slang%3D%22en-US%22%3ERe%3A%20Labels%20automatically%20resizing%20in%20form%20design%20-%20Access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555036%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742170%22%20target%3D%22_blank%22%3E%40Klippa%3C%2FA%3E%26nbsp%3BWell%20this%20was%20something%20i%20also%20noticed%20recently%20and%20i%20am%20curious%20how%20it%20evaded%20so%20many%20years...probably%20i%20have%20changed%20my%20design%20philosophy...%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3EThe%20issue%20only%20appears%20if%20you%20set%20the%20Text%20Formatting%20to%20Center...if%20you%20leave%20it%20to%20the%20default%20General%20it%20won't%20resize%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

Not sure if it is just me not seeing a setting somewhere. In previous versions I cannot remember this happening but it is rather annoying.

 

When in design mode of a form, if I change the text in a label, the label automatically resizes. Is there a global setting to turn this off? This is only relevant AFAIK to Access 2019, I use 2016 on desktop when in the office or using company laptop and do not have this issue. 

 

Basically my use is within a suite of database front ends I have developed, they all have the same type of form design so I can copy a form which does a similar function from one of the databases when building a new one to add into the suite. All my labels are nicely sized so everything is uniform, but when I type a different text into the label (e.g. change from Order Number to Employee Name) the label resizes itself and I have to then resize the label again so that it fulfils the requirement of my OCD.

 

Added a couple of example images. In image 1 I have taken a form which is used to add employee skills, made a copy and now changing this to add in an absence. Changing the label text automatically resized the label meaning I have to then go manually resize it to what it was previously.

 

Hope that is enough info. Sensible answers only please. I could write VBA or use Access 2016. I only require a response if there is a way to do this or not, and if possible how to prevent it from happening. Thanks in advance.

 

 

3 Replies
Highlighted

Are you editing through the label control itself or by changing the caption property in the Property Sheet?

Highlighted

@Daniel_Pineault I was editing directly in the label, but changing the caption property in the property sheet does prevent it from resizing which solves my issue. I can now just change the label caption there to avoid all the extra actions. I am sure in 13 and 16 I changed within the label and it didn't resize so will check that again tomorrow just for my own sanity, though I tend to just go on autopilot once I start working in Access. Thanks for your help, I knew it would be something simple!

Highlighted

@Klippa Well this was something i also noticed recently and i am curious how it evaded so many years...probably i have changed my design philosophy... :)

The issue only appears if you set the Text Formatting to Center...if you leave it to the default General it won't resize