Edit

Share via

Report.PageFooter property (Access)

  • Article

Use the PageFooter property to specify whether a report's page footer is printed on the same page as a report footer. Read/write Byte.

Syntax

expression.PageFooter

expression A variable that represents a Report object.

Remarks

The PageFooter property use the following settings.

Setting Visual Basic Description
All Pages 0 (Default) The page footer is printed on all pages of a report.
Not With Rpt Hdr 1 The page footer isn't printed on the same page as the report header.
Not With Rpt Ftr 2 The page footer isn't printed on the same page as the report footer. Microsoft Access prints the report footer on a new page.
Not With Rpt Hdr/Ftr 3 The page footer isn't printed on a page that has either a report header or a report footer. Access prints the report footer on a new page.

You can set the PageFooter property only in report Design view.

Access normally prints report page footers on every page in a report, including the first and last.

When forms are printed, page footers are always printed on all pages.

Example

The following example sets the PageFooter property for a report to Not With Rpt Hdr. To run this example, type the following line in the Debug window for a report named Report1.

Reports!Report1.PageFooter = 1

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.