Page headers in Microsoft Access 1

[Crauck]

I have a report that I am only printing a Group Header on its own page before each group (almost like a slip sheet between the different groups). But it is printing the Page Header on this page. I would like to know if there is a way to not print the Page Header on these pages only?


Any Ideas?

 

[scriverb]

Take a look at the Force New Page property of the Group Header section. Make sure that you don't have it set for Before this Section. Bob Scriver

 

[Crauck]

Nope I have it set to 'After Section' that is how I have it printing on its own page. I just don't know if there is a way to say only print the Page Header on certain pages. What do people do when they have column headings in their Page Header, and they only want it to print on certain pages?

 

[CosmoKramer]

I didn't get a chance to test this, but I think it might work.

In the On Page event of your report, check if a field from your report's group header is visible, and if so, make all of the fields in your page header not visible:

Private Sub Report_Page()
If Me!GroupHeaderField.IsVisible Then
 Me.PageHeaderField1.Visible = False
 Me.PageHeaderField2.Visible = False
 etc.........
End Sub

The space that the header would occupy would still be taken, but the fields should not appear. Try it and let us know.....

 

[Crauck]

Hooray! As far as I can tell it worked. Thanks for your help! It is much appreciated!

 

[Crauck]

Actually I checked it further and it only works on the first page of the report. None of the other Pages are right.

I am trying it different ways now but am having no luck.

Cristy