Export (0) Print
Expand All
Expand Minimize

Report.PageFooter Property (Access)

You can 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.

expression .PageFooter

expression A variable that represents a Report object.

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. Microsoft Access prints the report footer on a new page.

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

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

Note Note

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

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

Concepts

Other resources

Show:
© 2014 Microsoft