Access™ 2007 VBA Programmer's Reference

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 ...