Stop label controls on forms from changing width when editing label text

[hkeiner]

Is there a way to stop label controls on forms from auto-sizing (changing width) when editing the text in the label in design view?

Currently the label width decreases (or increases) to match the text entered/changed. I would prefer that the label width not change. I believe that this was not the default behavior of labels when using earlier versions of Access and perhaps started with Access 365. There does not seem to be a property under the Format tab on the Property Sheet to change this behavior. I'm hoping there is a more hidden property that can be changed using VBA code to turn this 'auto-size' feature off. If there is, I would simply write some VBA code to cycle through all the label controls on a form to turn the auto-sizing property off.

Thanks in advance for any info, even if it is a definitive response that this is not possible with Access 365 and that I'm stuck with this auto-size behavior.

[OBP]

Sorry, I don't know Access 365.
But as you say older versions have fixed width labels that you control with the Width property.
They do not have a "can grow" or "can shrink" property.

[richardmiami]

Hey there, thanks for asking. What programm software are you using? Have you tried checking for essay papers (https://www.proessaywriting.com/essay-paper/)? As far as I know older versions of Access 365 had manual Width control. Hope I was of use.

[HiTechCoach]

Is there a way to stop label controls on forms from auto-sizing (changing width) when editing the text in the label in design view?

Currently the label width decreases (or increases) to match the text entered/changed. I would prefer that the label width not change. I believe that this was not the default behavior of labels when using earlier versions of Access and perhaps started with Access 365. There does not seem to be a property under the Format tab on the Property Sheet to change this behavior. I'm hoping there is a more hidden property that can be changed using VBA code to turn this 'auto-size' feature off. If there is, I would simply write some VBA code to cycle through all the label controls on a form to turn the auto-sizing property off.

Thanks in advance for any info, even if it is a definitive response that this is not possible with Access 365 and that I'm stuck with this auto-size behavior.

To avoid this issue, I edit the label caption in the property sheet.

[OBP]

The property sheet can be accessed when the Form or report is in design view.

[Firepen]

As OBP says, be in Design view. Make sure you are under the Disign Tab on the top bar -there is a toggle button for properties in the tools section on the right hand side. Or better yet, press F4. This is based on Access 2019 but should work for most versions.