Section Members (Access)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Events

Name

Description

Click

The Click event occurs when the user presses and then releases a mouse button over an object.

DblClick

The DblClick event occurs when the user presses and releases the left mouse button twice over an object within the double-click time limit of the system.

MouseDown

The MouseDown event occurs when the user presses a mouse button.

MouseMove

The MouseMove event occurs when the user moves the mouse.

MouseUp

The MouseUp event occurs when the user releases a mouse button.

Paint

Occurs when the specified section is redrawn.

Methods

Name

Description

SetTabOrder

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

Properties

Name

Description

AlternateBackColor

Gets or sets the background color to display on alternate rows of the specified section. Read/write Long.

AlternateBackShade

Gets or sets the shade applied to the theme color in the AlternateBackColor property of the section. Read/write Single.

AlternateBackThemeColorIndex

Gets or sets a value that represents a color in the applied color theme associated with the AlternateBackColor property of the section. Read/write Long.

AlternateBackTint

Gets or sets the tint applied to the theme color in the AlternateBackColor property of the section. Read/write Single.

Application

You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.

AutoHeight

Gets or sets whether a section's height is adjusted automatically when controls are resized. Read/write Boolean.

BackColor

Gets or sets the interior color of the specified object. Read/write Long.

BackShade

Gets or sets the shade applied to the theme color in the BackColor property of the specified object. Read/write Single.

BackThemeColorIndex

Gets or sets a value that represents a color in the applied color theme associated with the BackColor property of the specified object. Read/write Long.

BackTint

Gets or sets the tint that is applied to the theme color in the BackColor property of the specified object. Read/write Single.

CanGrow

Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the control contains. Read/write Boolean.

CanShrink

Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data the section or control contains. Read/write Boolean.

Controls

Returns the Controls collection of a form, subform, report or section. Read-only Controls.

DisplayWhen

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

EventProcPrefix

Gets or sets the prefix portion of an event procedure name. Read/write String.

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. Read/write Byte.

HasContinued

You can use the HasContinued property to determine if part of the current section begins on the previous page. Read/write Boolean.

Height

Gets or sets the height of the specified object in twips. Read/write Integer.

InSelection

You can use the InSelection property to determine or specify whether a control on a form in Design view is selected. Read/write Boolean.

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). Read/write Boolean.

Name

You can use the Name property to specify or determine the string expression that identifies the name of an object. Read/write String.

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. Read/write Byte.

OnClick

Sets or returns the value of the On Click box in the Properties window. Read/write String.

OnDblClick

Sets or returns the value of the On Dbl Click box in the Properties window. Read/write String.

OnFormat

Sets or returns the value of the On Format box in the Properties window of a report section. Read/write String.

OnMouseDown

Sets or returns the value of the On Mouse Down box in the Properties window. Read/write String.

OnMouseMove

Sets or returns the value of the On Mouse Move box in the Properties window. Read/write String.

OnMouseUp

Sets or returns the value of the On Mouse Up box in the Properties window. Read/write String.

OnPaint

Sets or returns the value of the On Paint box in the Properties window of a form or report. Read/write String.

OnPrint

Sets or returns the value of the On Print box in the Properties window of a report section. Read/write String.

OnRetreat

Sets or returns the value of the On Retreat box in the Properties window of a report section. Read/write String.

Parent

Returns the parent object for the specified object. Read-only.

Properties

Returns a reference to a control's Properties collection object. Read-only.

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. Read/write Boolean.

SpecialEffect

You can use the SpecialEffect property to specify whether special formatting will apply to the specified object. Read/write Byte.

Tag

Stores extra information about a form, report, section, or control needed by a Microsoft Access application. Read/write String.

Visible

Returns or sets whether the object is visible. Read/write Boolean.

WillContinue

Determines if the current section will continue on the following page. Read/write Boolean.