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