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).