Need to hide header on first page of a report 1

[mrwog]

I have created several reports based on forms. Most of the input results in a single page printed form. But on the occasions when the detail cause the form to extend to multiple pages, I would like to have a header on the second and subsequent pages.

Is there a way to create a header that only prints if the page number is greater than 1?

Thanks in advance.

 

[dhookom]

I hope your reports are reports and not forms that you are printing. You can use code in the On Format event of the page header that would hide it if Page = 1

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Me.Page = 1
End Sub

You might need to display the page number or at least bind it to a control in the page header section.

Duane
Hook'D on Access
MS Access MVP