Remove part of Page Header on last page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has a Page Header that I want to print on every page,
except on the last page, where I only want some of the information from the
Page Header to print. I tried adding code to remove the information by making
these controls invisible on the ReportFooter_Print event, which previews
fine, but when it's actually printed it makes these controls invisible on all
pages. Is this possible to do?
 
In the PageFooter OnFormat event write the code

'Check if last page and return the oposite value to hide the text box
Me.TextBoxName.Visible = Not ( [Page] = [Pages])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning page header on and off 5
page header on second page of invoice. 3
Prevent skip to new page after last page prints 3
multi-column sub report repeat page header 2
Page Header Not Printing On Every Page 6
Print objects only on the last page of a report 2
Report - Don't print the page footer on the last page 6
Access Page Header with merge field 0

Back
Top