Report.Section property (Access)

Use the Section property to identify a section of a report and provide access to the properties of that section. Read-only Section object.

Syntax

expression.Section (Index)

expression A variable that represents a Report object.

Parameters

Name	Required/Optional	Data type	Description
Index	Required	Variant	The section number or name.

Remarks

The Section property corresponds to a particular section. Use the following constants. We recommend that you use the constants to make your code easier to read.

Setting	Constant	Description
0	acDetail	Report detail section
1	acHeader	Report header section
2	acFooter	Report footer section
3	acPageHeader	Report page header section
4	acPageFooter	Report page footer section
5	acGroupLevel1Header	Group-level 1 header section
6	acGroupLevel1Footer	Group-level 1 footer section
7	acGroupLevel2Header	Group-level 2 header section
8	acGroupLevel2Footer	Group-level 2 footer section

Note

If a report has additional group-level sections, the header/footer pairs are numbered consecutively beginning with 9.

The Section property is an array of all existing sections in the form or report specified by the section number. For example, Section(0) refers to a form's detail section, and Section(3) refers to a form's page header section.

You can also refer to a section by name. The following statements refer to the Detail0 section for the Customers form and are equivalent.

Forms!Customers.Section(acDetail).Visible

Forms!Customers.Section(0).Visible

Forms!Customers.Detail0.Visible

You must combine the Section property with other properties that apply to form or report sections.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.