Class Section (Access VBA)

A form section is part of a form such as a header, footer, or detail section.

The classes Form and Report. give access to class Section

Methods

SetTabOrder - Resets the tab order of the controls in the specified Section to their default values.

Properties

AlternateBackColor gets or sets the background color to display on alternate rows of the specified section.

AlternateBackShade gets or sets the shade applied to the theme color in the AlternateBackColor property of the section.

AlternateBackThemeColorIndex gets or sets a value that represents a color in the applied color theme associated with the AlternateBackColor property of the section.

AlternateBackTint gets or sets the tint applied to the theme color in the AlternateBackColor property of the section.

AutoHeight gets or sets whether a section's height is adjusted automatically when controls are resized.

BackColor gets or sets the interior color of the specified object.

BackShade gets or sets the shade applied to the theme color in the BackColor property of the specified object.

BackThemeColorIndex gets or sets a value that represents a color in the applied color theme associated with the BackColor property of the specified object.

BackTint gets or sets the tint that is applied to the theme color in the BackColor property of the specified object.

CanGrow gets or sets whether the specified control automatically adjusts vertically to print or preview all the data that the control contains.

CanShrink gets or sets whether the specified control automatically adjusts vertically to print or preview all the data that the section or control contains.

Controls returns the Controls collection of a form, subform, report, or section.

DisplayWhen you can use the DisplayWhen property to specify which of a form's sections you want displayed on screen and in print.

EventProcPrefix gets or sets the prefix portion of an event procedure name.

ForceNewPage you can use the ForceNewPage property to specify whether form sections (detail, footer) or report sections (header, detail, footer) print on a separate page rather than on the current page.

HasContinued you can use the HasContinued property to determine if part of the current section begins on the previous page.

Height gets or sets the height of the specified object in twips.

InSelection you can use the InSelection property to determine or specify whether a control on a form in Design view is selected.

KeepTogether you can use the KeepTogether property for a section to print a form or report section all on one page. For example, you might have a group of related information that you don't want printed across two pages. The KeepTogether property applies only to form and report sections (except page headers and page footers).

Name you can use the Name property to specify or determine the string expression that identifies the name of an object.

NewRowOrCol you can use the NewRowOrCol property to specify whether a section and its associated data is printed in a new row or column within a multiple-column report or multiple-column form.

OnClick sets or returns the value of the On Click box in the Properties window.

OnDblClick sets or returns the value of the On Dbl Click box in the Properties window.

OnFormat sets or returns the value of the On Format box in the Properties window of a report section.

OnMouseDown sets or returns the value of the On Mouse Down box in the Properties window.

OnMouseMove sets or returns the value of the On Mouse Move box in the Properties window.

OnMouseUp sets or returns the value of the On Mouse Up box in the Properties window.

OnPaint sets or returns the value of the On Paint box in the Properties window of a form or report.

OnPrint sets or returns the value of the On Print box in the Properties window of a report section.

OnRetreat sets or returns the value of the On Retreat box in the Properties window of a report section.

Properties returns a reference to a control's Properties collection object.

RepeatSection you can use the RepeatSection property to specify whether a group header is repeated on the next page or column when a group spans more than one page or column.

SpecialEffect you can use the SpecialEffect property to specify whether special formatting will apply to the specified object.

Tag stores extra information about a form, report, section, or control needed by a Microsoft Access application.

Visible returns or sets whether the object is visible.

WillContinue determines if the current section will continue on the following page.

Properties - The Properties collection contains all the built-in properties in an instance of an open form, report, or control. These properties uniquely characterize that instance of the object.