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

Me.Section(Index)
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

https://msdn.microsoft.com/en-us/library/office/ff192668.aspx

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

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

Leave a Reply

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