On Print / On Format Event

[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

 

[Jeff Boyce]

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

 

[Josh Burkard]

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

 

[Jeff Boyce]

Josh

So, you're saying that you have that code in BOTH the OnPrint and OnFormat
events? What happens when you only have it in one of these (try OnFormat
first)?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

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

 

[Josh Burkard]

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.

 

[Jeff Boyce]

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/