Report Header/Footer Config. (1 Viewer)

GUIDO22

Registered User.
Local time
Today, 12:03
Joined
Nov 2, 2003
Messages
515
I have generated an Access report that I am proposing to have hosted as PDF file on a website for clients to download... (so it is not being dynamically generated by Access).
The last page of the report I want to include some notes on use of the information on the preeceding pages... I guess the only way I can do this is to have a/some text fields containing the text I want- in the Report_Footer. Only issue is that the report header - which shows column headers for the tabulated data from the preceeding pages - still appears at the top of this page which I dont want.
Is there any way that you I can prevent the header from appearing on the last page of the report.. in VBA code perhaps according to a specific page number..?
 

Minty

AWF VIP
Local time
Today, 12:03
Joined
Jul 26, 2013
Messages
10,354
You can hide it, if it's the last page based on a count
If Page = Pages Then ....
But make sure it's not on the first page or you don't get the header at all.
 

GUIDO22

Registered User.
Local time
Today, 12:03
Joined
Nov 2, 2003
Messages
515
You can hide it, if it's the last page based on a count
If Page = Pages Then ....
But make sure it's not on the first page or you don't get the header at all.
Thanks - would the page increment / checking code go in the Report_footer Format event..?
 

GUIDO22

Registered User.
Local time
Today, 12:03
Joined
Nov 2, 2003
Messages
515
Yes, the format event.
I have used this code to test...

If (Report.Page = Report.Pages) Then
Me.PageHeaderSection.Visible = False
End If

I have stepped through in the code and this property is set to False, but when the report displays, its still there.. any ideas..?
 

Minty

AWF VIP
Local time
Today, 12:03
Joined
Jul 26, 2013
Messages
10,354
Make sure you are looking at it in print preview mode not report mode.
Try removing the Report. from your references, I'm sure I simply used Page = Pages when I last did this.
 

GUIDO22

Registered User.
Local time
Today, 12:03
Joined
Nov 2, 2003
Messages
515
Make sure you are looking at it in print preview mode not report mode.
Try removing the Report. from your references, I'm sure I simply used Page = Pages when I last did this.
Default view for Report is Print Preview and I am viewing in Print Preview mode.
I have removed the Report prefix but the problem persists....
 

GUIDO22

Registered User.
Local time
Today, 12:03
Joined
Nov 2, 2003
Messages
515
OK - my mistake I had the code to hide in the Report Footer format event and not the Report Header event ... now working fine!
Thanks for your help
 

Minty

AWF VIP
Local time
Today, 12:03
Joined
Jul 26, 2013
Messages
10,354
Ah - that will make a difference - Glad you sorted it!
 

Users who are viewing this thread

Top Bottom