Form Section, Report Section, Subform/Subreport Control, Text Box Control.
You can use the CanGrow and CanShrink properties to control the appearance of sections on reports and controls on forms that are printed. For example, if you set both properties to Yes, a section or control automatically adjusts vertically to print or display all the data the report or form contains.
Note The CanGrow and CanShrink properties do not apply to form or report header and footer sections.
The CanGrow property uses the following settings.
Setting | Description | Visual Basic |
Yes | The section or control grows vertically so that Microsoft Access can print all the data it contains. | True (-1) |
No | (Default) The section or control doesnt grow. Data that cant be seen wont be printed. | False (0) |
The CanShrink property uses the following settings.
Setting | Description | Visual Basic |
Yes | The section or control shrinks vertically so that Microsoft Access can print the data it contains without leaving blank lines. | True (-1) |
No | (Default) The section or control doesnt shrink. | False (0) |
You can set these properties only in the property sheet.
For controls, you can set the default for these properties using the default control style.
These property settings are read-only in Visual Basic.
If you set a controls CanGrow property to Yes, Microsoft Access automatically sets the CanGrow property of the section containing the control to Yes.
Sections grow and shrink vertically across their entire width. However, report header and footer sections will not grow, even if the CanGrow property of a control is set to Yes.
When you use the CanGrow and CanShrink properties, remember that:
Format Event, Retreat Event.