G.15. The Section Object
Every form or report contains several Section objects including the header, footer, and detail sections. Each section has a number of properties and methods you can use within your code.
A Section object has only one method: SetTabOrder. It enables you to programmatically set the tab order for all controls in a section. Calling this method is the equivalent of using the Auto Order button in the Tab Order dialog box.
G.15.1. Section Object Properties
The properties of the Section object are described in the following table.
Property | Data Type | Description |
---|---|---|
AlternateBackColor | Long | Specifies the alternating row color for a section. It is now easy to change the row color for every other section on a form or report! |
Application | Application object | Returns the currently active application. |
AutoHeight | Boolean | Indicates whether a section should grow automatically when controls are resized. |
BackColor | Long | Specifies the color for the interior of a section. |
CanGrow | Boolean | True if you want the section to automatically grow to print or preview all data within the section. |
CanShrink | Boolean | True if you want the section to automatically shrink to print or preview only the data within the section (with no extra space). |
Controls | Controls collection | References all of the controls within the section. |
DisplayWhen | Byte | Controls which sections you want displayed on screen and in print. |
EventProcPrefix | String | Used to get the prefix portion of an event procedure name. |
ForceNewPage | Byte | Specifies when sections ... |
Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.