Monday, April 9, 2018

PageHeader Property

PageHeader Property

Applies to

Report Object

You can use the PageHeader property to specify whether a report's page header is printed on the same page as a report header. Read/write Byte.

expression.PageHeader

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

The PageHeader property use the following settings.

Setting

Visual Basic

Description

All Pages

0

(Default) The page header is printed on all pages of a report.

Not With Rpt Hdr

1

The page header isn't printed on the same page as the report header.

Not With Rpt Ftr

2

The page header isn't printed on the same page as the report footer. Microsoft Office Access 2007 prints the report footer on a new page.

Not With Rpt Hdr/Ftr

3

The page header 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.


Note: You can set these properties by using the report's property sheet, a macro, or Visual Basic for Applications (VBA) code.

You can set the PageHeader property in Design view or Layout view.

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

In report Design view, click Page Header/Footer under Show/Hide on the Arrange tab to display the page header and page footer sections.

Note: When forms are printed, page headers are always printed on all pages.

Example

The following example sets the PageHeader 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.PageHeader = 1

No comments:

Post a Comment