Conditional Page Footer

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am trying to print a report with the Page footer section printing
only on odd page numbers. The report is printed in duplex. I set
[Page] to 1 on Open Report. I have been able to successfully
conditionally print the page header on odd pages only (in the same
report).

For some reason, the page footer still shows up on page 1 of the
report, and then prints correctly on the remaining pages (although it
looks correct in print preview).

The code I use "On Format" in the Page Footer section is:

If Me.Page Mod 2 = 0 Then
Me.PageFooterSection.Visible = True
Else
Me.PageFooterSection.Visible = False
End If

Thanks in advance.
 
Did you misstate your question? You said you want to print the page footer
section only on odd pages, isn't page 1 odd?
 
Sorry, I just unintentionally ommitted some information.

In the page header section, I was able to use the correct logic. (ie
if odd page then Me.PageFooterSection.Visible = True) In the page
footer section, I have to use the opposite logic just to get it to
work, partially. As I said previously, it works for all pages, except
page 1. It is as if it doesn't see the first page number when it
formats in the footer.

Thanks,
Jeff

GVaught said:
Did you misstate your question? You said you want to print the page footer
section only on odd pages, isn't page 1 odd?

Jeff said:
I am trying to print a report with the Page footer section printing
only on odd page numbers. The report is printed in duplex. I set
[Page] to 1 on Open Report. I have been able to successfully
conditionally print the page header on odd pages only (in the same
report).

For some reason, the page footer still shows up on page 1 of the
report, and then prints correctly on the remaining pages (although it
looks correct in print preview).

The code I use "On Format" in the Page Footer section is:

If Me.Page Mod 2 = 0 Then
Me.PageFooterSection.Visible = True
Else
Me.PageFooterSection.Visible = False
End If

Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top