Clever Geek Handbook

Access Report PageHeader not with GroupHeader

I am stuck with the following:

I have an Access2003 report "rptInvoices". Group levels refer to CustomerID and PackingListID.

What I like is that every second (or third, etc.) invoice page starts with a blank section (e.g. 9cm) at the top of the page. For this I would use an empty PageHeader section. If the ReportHeader property has a value such as NotWithGroupHeaderX, this should be easy.

Since there is no such value: how can I hide the PageHeader file in the report if that page has a GroupHeader named grhCustomerID?

Maybe I need a different approach, but I just don't see it.

0


source to share


2 answers


In groupheader, format event

set pageheadersection.visible

to true

so that the page title prints pages after the group title. In the group footer format event, set pageheadersection.visible

to false

so that the page title does not print at the top of the next page with the group title.



+1


source


You can set the visible property of the page title in the group title format event.



Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    Me.PageHeaderSection.Visible = False
End Sub

Private Sub Report_Page()
    Me.PageHeaderSection.Visible = True
End Sub
0


source






More articles:


All Articles