Making Microsoft Access Form and Report Controls Grow

You have control!! Access Form and Report Controls

Did you ever notice that when you print an Access Report, some of the text is missing from variable-length fields (e.g., a text or memo field)? If there is too much text to display in the text box, the text is truncated (cut off).
Instead of resizing the control to be a set length, you can set the Can Grow property to “Yes” and the text box will expand vertically depending on the contents of the field for each record.
Data that is shorter than the defined size of a text control will result in Access printing blank lines. To eliminate the extra space, use the Can Shrink property.
Here’s how to get to these properties:
  • In Design view, right-click the text control you want to resize, and select Properties.
  • On the Format tab, click Can Grow, and select Yes from the drop-down list (that will allow your field to expand).
  • On the Format tab, click Can Shrink, and select Yes from the drop-down list (that will close up any extra space if the field is blank).

[otw_shortcode_button href=”https://www.fullcirclecomputing.com/microsoft-access-training/” size=”large” icon_position=”left” shape=”radius” target=”_blank”]Access Course Outlines, Prices & Upcoming Dates??
Click Here!![/otw_shortcode_button]

Questions? Contact us for more information or schedule a class for your team!