Page header only show up on page two of access report

  • Thread starter Thread starter gumby
  • Start date Start date
G

gumby

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


David
 
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
..
 
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.
 
Back
Top