07-28-2020 04:39 AM
07-28-2020 04:39 AM
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.
07-29-2020 09:52 AM
Are you editing through the label control itself or by changing the caption property in the Property Sheet?
07-29-2020 03:24 PM
@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!
07-30-2020 12:12 AM
@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