Hiding pg footer rpt header

gem1204

Registered User.
Local time
Yesterday, 21:21
Joined
Oct 22, 2004
Messages
54
I have a report that prints the report header and footer on seperate pages. The only problem is that the page footer and page header show on the pages with the report header. Since the report header and footer show on seperate pages I don't need the page footer to show on these pages. How do you suppress the page header and footer on the pages with the report header and footer?
Thanks
 
Why not clean the two up so you can avoid using code and avoid potentially making things buggy?
 
Sorry Crilen007 - I don't have a clue what you are talking about. Clean up what? What code
 
I got the answer from another site. Here it is in case anyone wants it. If you try to keep things from getting "buggy", then you'll ......... never mind

In the on format event for the page header and/or footer put in the following code (I tried to make it more buggy and confusing than it really is)

If Page = Pages - Pages + 1 Or Page = Pages Then
Cancel = True
Else
Cancel = False
End If
 

Users who are viewing this thread

Back
Top Bottom