Make a text box grow or shrink to fit data when printing a form or report

1. Open the form or report in Design view.
2. Select the text box, and then click Properties on the toolbar.
3. Set the CanGrow or CanShrink property to Yes.

   CanGrow expands the text box vertically to fit the data in the field when the form or report is printed.

   CanShrink reduces the text box vertically if there is no data in the field when the form or report is printed.

Note   When you set the CanGrow property to Yes for a text box, Microsoft Access automatically sets the CanGrow property of the section to Yes.