Page header only show up on page two of access report

[gumby]

Can you make the page header only show up on the pages two and on in
an Access report?


David

 

[John Spencer]

Add code to the Format event of the page header as follows.

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(acPageHeader).Visible = Me.Page <> 1
End Sub


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[fredg]

Can you make the page header only show up on the pages two and on in
an Access report?

David

In addition to John's answer, if the report has a report header, you
can set the report's Page Header property to Not with rpt header.
It's on the Report property sheet's Format tab.