Preview is different from Printed

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

I have a report on which I don't want the page footers to print except on
the last page (first page if only one). I have set the initial visible
property of the footer to false. I have set the properties for the
PageHeader_Format section to:

If Me.Page = Me.Pages Then
Section(acPageFooter).Visible = True
End If

This works in preview but when printed (from preview) it prints them on
every page. If you print directly it is fine. Also if there is only one
page it doesn't print the footer.

Bill Wild
(e-mail address removed)
 
Your code makes the footer visible when it is previewed, but then nothing
turns it off when printed from preview.

See if this helps.
In the Report PageHeader Format event:

Me.Section(4).Visible = [Page] = [Pages]
 
Back
Top