Create controls that grow with an Access report's data

When you initially create a report that displays variable-length fields, it is difficult to determine just how to size a text box control vertically so that no data is truncated for any record. Discover how you can use Access' Can Grow property to automatically resize the control to display the exact contents of each record.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

When you print a report in Microsoft Access, some of the data may be missing from variable-length fields (such as Memo fields) because the text box controls aren't large enough to display all of the data. You can manually resize the control to accommodate the additional data, or you can set the Can Grow property to automatically expand the text box vertically depending on the contents of the field for each record.

To take advantage of the Can Grow property, follow these steps:

  1. In Design view, right-click the text control you want to resize, and select Properties.
  2. On the Format tab, click Can Grow, and select Yes from the drop-down list.

When you run the report, the control will automatically expand to accommodate additional lines of data when the data is larger than the control.

Data that's too short for the defined size of a text control will cause Access to print blank lines. To have the control automatically resize to eliminate blank lines, follow the same steps for the Can Shrink property.

Editor's Picks

Free Newsletters, In your Inbox