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

1. Open the form in Design view or the report in Design view.
   
   
2. To display the property sheet, make sure the text box is selected, 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.

   To see examples of text boxes that grow or shrink, click .

Notes  

• When you set the CanGrow property to Yes for a text box, Microsoft Access automatically sets CanGrow to Yes for the section.
  
  
• The Catalog and Invoice reports in the Northwind sample database have examples of text boxes that grow. To view these reports, open the Northwind database in your Office folder's Samples folder, and then open the report you want to see in Design view. For information on opening Northwind, click .