You can use the CanGrow property to control the appearance of sections or controls on forms and reports that are printed or previewed. For example, if you set the property to Yes, a section or control automatically adjusts vertically to print or preview all the data the section or control contains.
Notes
The CanGrow property does not apply to a form or report page header and page footer sections, although it does apply to controls in such sections.
This property affects the display of form sections and controls only when the form is printed or previewed, not when the form is displayed in Form view, Datasheet view, or Design view.
