PageFooter Property
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 Required. An expression that returns one of the objects in the Applies To list.
Remarks
The PageHeader and PageFooter properties 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.
In report Design view, click Page Header/Footer on the View menu to display the page footer sections.
Note 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