Darrell
Registered User.
- Local time
- Today, 00:30
- Joined
- Feb 1, 2001
- Messages
- 299
Hi guys,
I've got this report (well it's not actually mine but I'm helping...) where there is a graph in the report footer and so the user would like the page header and footer removed from the last page of the report.
Now I've had a bit of a look around and I found this which has mostly worked...
Private Sub Report_Page()
If Me.Page Mod 2 = 0 Then
Me.PageHeaderSection.Visible = False
Me.PageFooterSection.Visible = False
Else
Me.PageHeaderSection.Visible = True
Me.PageFooterSection.Visible = True
End If
End Sub
The only problem is that is has removed the header and footer from page 3 of the report as well as the last page, and unfortunately my knowledge of this stuff isn't up to working out why.
Is anyone able to shed some light on this?
Cheers
dh
I've got this report (well it's not actually mine but I'm helping...) where there is a graph in the report footer and so the user would like the page header and footer removed from the last page of the report.
Now I've had a bit of a look around and I found this which has mostly worked...
Private Sub Report_Page()
If Me.Page Mod 2 = 0 Then
Me.PageHeaderSection.Visible = False
Me.PageFooterSection.Visible = False
Else
Me.PageHeaderSection.Visible = True
Me.PageFooterSection.Visible = True
End If
End Sub
The only problem is that is has removed the header and footer from page 3 of the report as well as the last page, and unfortunately my knowledge of this stuff isn't up to working out why.
Is anyone able to shed some light on this?
Cheers
dh