Results 1 to 14 of 14
  1. #1
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6

    Label Auto-Resizing - I want it to STOP!!!

    Hi,



    In older access versions (2010 minus) a stand-alone label never auto-resized. However, in newer access versions (2016+) when I have a label, and center text, it auto-resized to the size of the text.

    Duplicate this problem:
    - Create a label
    - Leave text general, or left aligned
    - Make the width of the label larger than the text 'test'
    - Type in the label 'test' and enter - the label does not resize
    - Change text to center aligned
    - Make the width of the label larger than the text 'stop'
    - Type in the label 'stop' and enter - the label resizes to the size of the text

    STOP IT!

    Any ideas how to prevent this?

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    I don't see that behavior in either 2016 or 2019.
    Maybe it's some setting that I'm not familiar with.
    Can you upload a DB that exhibits the problem?

  3. #3
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6
    Quote Originally Posted by davegri View Post
    I don't see that behavior in either 2016 or 2019.
    Maybe it's some setting that I'm not familiar with.
    Can you upload a DB that exhibits the problem?

    Here is a simple example - 1 form, 2 fields; one left aligned, one center aligned. Both labels are very wide. Type in any word into both. The left aligned label doesn't resize; the center aligned label resizes.

    Created in Access 2019.

    To be clear - I'm talked about editing the text/caption of the label in design view.
    Attached Files Attached Files

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    This post was all wrong. See next post.
    Last edited by davegri; 07-12-2020 at 06:25 PM. Reason: add

  5. #5
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Access 2019 -
    You'll have to delete the label and re-create it. Once "[Size] To Fit" is clicked the label will possess the resize problem and can't be unclicked, so don't do that.
    This appears to be a bug in Access.

    Click image for larger version. 

Name:	FIT.png 
Views:	33 
Size:	40.1 KB 
ID:	42424
    Last edited by davegri; 07-13-2020 at 06:32 AM. Reason: bug

  6. #6
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6
    Quote Originally Posted by davegri View Post
    Access 2019 -
    You'll have to delete the label and re-create it. Once "[Size] To Fit" is clicked the label will possess the resize problem and can't be unclicked, so don't do that.
    This appears to be a bug in Access.

    Click image for larger version. 

Name:	FIT.png 
Views:	33 
Size:	40.1 KB 
ID:	42424

    Ok - thanks. So it looks like there is no way to NOT have it as '[Size] To Fit'....every label created has it, no way to start without it?

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Are you sure new label has this aspect if you don't click "To Fit"?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Once "[Size] To Fit" is clicked the label will possess the resize problem and can't be unclicked, so don't do that.
    Like I said, when you create a label, don't click that. Any existing label that has the resize problem needs to be deleted and recreated.

  9. #9
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6
    I tried that. I created a label, brand new in a brand new db.
    Centered the text.
    Typed in something - it resized.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I downloaded your db and did the test you outlined.

    Neither label resizes.

    I am running Access 2010.

    Since davegri running 2016/2019 also cannot replicate issue and cannot identify an app option that causes this, this may be a 'feature' of Office 365 Access you will have to get used to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6
    I think Access 2010 is the last version I had it worked. It does the resize problem in both Access 2016 and Access 2019.

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Interesting, davegri shows using 2016/2019 and said not seeing issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    I investigated this some more. The label only resizes if you update its caption by typing in the label in design view, and it loses focus.

    If you don't type directly in the label, but set its caption from the property sheet, it won't resize. If you then alter the caption in code, it won't resize.

    To solve the problem simply don't type the caption directly into the label on the form.

  14. #14
    nub is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    6
    Very nice! So that seems to be the work around...hopefully MS fixes this in a patch as it shouldn't do it typing directly in the label either. But this will work for now. Thanks for all the investigating!

    Quote Originally Posted by davegri View Post
    I investigated this some more. The label only resizes if you update its caption by typing in the label in design view, and it loses focus.

    If you don't type directly in the label, but set its caption from the property sheet, it won't resize. If you then alter the caption in code, it won't resize.

    To solve the problem simply don't type the caption directly into the label on the form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Stop auto increment of decimal value to 1
    By SierraJuliet in forum Forms
    Replies: 3
    Last Post: 01-24-2019, 01:10 AM
  2. Replies: 2
    Last Post: 10-18-2016, 07:07 AM
  3. Stop Form Auto populate
    By newtoaccess2 in forum Forms
    Replies: 4
    Last Post: 10-15-2014, 10:13 AM
  4. Auto Resizing Grid Control
    By shaferda in forum Forms
    Replies: 1
    Last Post: 02-14-2012, 09:38 PM
  5. auto start/stop time
    By j0ker21m in forum Reports
    Replies: 1
    Last Post: 12-10-2005, 08:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums