Share via


Report.PageFooter Property

Access Developer Reference

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.

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

Bb237678.vs_note(en-us,office.12).gif  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.

Visual Basic for Applications
  Reports!Report1.PageFooter = 1

See Also