Control Page Headers with VBA?

[FL_Boy]

I've got a report and I don't want the Page Header to displayed on the page the group header is printed on. (My group header is about the whole first page of a particular group.)


I've seen where you can turn off page headers for report header pages. What's the best way to turn them off for group headers? I'd like to use VBA to turn them off on the on format event for the group header and then back on using the on format for the detail. Does that sound about right?

thanks

[June7]

Don't know, never tried. Do you have some code we could analyse? Anything found in Google search?

[FL_Boy]

I have searched a bit on google and the forums.
I've been able to turn off the headers in the group by code, but when I turn them back on in the detail on format event, the page header section doesn't show until the 2nd and subseqent detail pages.

I've tried forcing a new page at the group level and it doesn't help. I've also tried forcing a new page 'before section' in the detail and the page header still doesn't show up prior the 2nd page.

Any suggestions?



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

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.PageHeaderSection.Visible = True
End Sub

[June7]

I found a thread that appears to be your exact issue. It suggests:

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