You discuss the "can shrink" / "can grow" options for the CompanyName textbox (and the other textboxes as well). You also show it working - as it should. Cool.
However, I have found that if you have an additional textbox "TB" (or any other object) that is placed in-line horizontally anywhere within the height of this textbox, the CompanyName textbox will not shrink if it is empty AND the TB textbox has contents.
In my observations both of these text boxes are set to yes for can shrink and can grow. Is this a known issue with Access? (using Access 2010)
Reply from Richard Rost:
You are correct, Chris. If you have two text boxes in line horizontally, then BOTH of them have to be empty for them to "shrink" up. Likewise, if you have a LABEL in that line, it will NEVER allow those boxes to shrink up. This is just how Access is designed, and you have to take it into consideration when building your reports. The only alternative is to use some VBA to manually hide fields in the section build event.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 5.
