Access Report Section Property

This Access tutorial explains how to use Access Report Section Property to control Report Section such as Page Header, Footer.

Access Report Section Property

In Access Report VBA, you can directly access the Controls in the Report, it is also possible to access the Report Sections using Report Section Property, such as Page Header, Group Header, Page Footer, etc. This is especially useful to hide the whole Section.

Syntax of Report Section Property

Index 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

Example of Access Report Section Property

To hide Group Header Section in an Event

Me.Section(5).Visible = False

You may also read my another example below

Access Report page break by Group and add blank page

Outbound References

Wyman W
Compensation Survey Manager@Mercer
Wyman is human resources professional, specialized in business analysis, project management, data transformation with Access and Excel.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

You may drop me a message if you are interested in HR consultancy services from Mercer.

Leave a Reply

Your email address will not be published. Required fields are marked *