On Print / On Format Event

  • Thread starter Thread starter Josh Burkard
  • Start date Start date
J

Josh Burkard

Hello together

i created some Reports with On Print and / or On Format Events in which i will show and hide Page Footers

My problem is that the reports shows OK in Print Preview, but differs by printing.

What can i do?

Best regards
Josh
 
Josh

"differs" in what way(s)?

A more specific description may result in more specific suggestions...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Hello together

i created some Reports with On Print and / or On Format Events in which i
will show and hide Page Footers

My problem is that the reports shows OK in Print Preview, but differs by
printing.

What can i do?

Best regards
Josh
 
OK. My code in On Print and On Format Event looks like:

If Page = Pages Then
PageFooterSection.Visible = True
Else
PageFooterSection.Visible = False
End If

Cause i only want to show the PageFooter on the last page.

In Print Preview i see the PageFooter on the last page only. In real
Printing, i see the PageFooter on every Page.

Best regards
Josh
 
i tried it in On Format and in On Print seperatly.

i tried the Code also in PageHeader-, Details- and in PageFooter-Section
separatly.

In the PrintPreview it works only in PageHeader-OnFormat and in
PageHeader-OnPrint.
 
Josh

I'm as puzzled by this as you are.

Were this mine, I'd probably try creating a new report, to see if the old
one had been somehow subtly corrupted. Other than that, perhaps another
newsgroup reader can offer suggestions...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top