Different formatting for odd/even pages

[Guest]

I need to reformat a purchase order report to print a new "signature" page
footer after the Detail section on every odd page number and to print a full
page of terms & conditions without a page footer on every even page number.
When the report is printed to a duplex printer, the odd pages will be the
"front" pages and the even pages will be the "back" pages.

I have tried several different layouts - moving the "signature" page footer
to the subreport, using On Format to set the "signature" page footer Visible
to False on even page numbers, making the report 2 page wide - but no luck in
getting the formatting like I need it.

Is this even possible to do in Access?

Any suggestions would be GREATLY appreciated!

 

[Marshall Barton]

I need to reformat a purchase order report to print a new "signature" page
footer after the Detail section on every odd page number and to print a full
page of terms & conditions without a page footer on every even page number.
When the report is printed to a duplex printer, the odd pages will be the
"front" pages and the even pages will be the "back" pages.

I have tried several different layouts - moving the "signature" page footer
to the subreport, using On Format to set the "signature" page footer Visible
to False on even page numbers, making the report 2 page wide - but no luck in
getting the formatting like I need it.

Try making the page footer visible or invisible in the Page
Header's Format event:

Me.Section(4).Visible = (Me.Page Mod 2 = 1)

 

[steve]

I was reading this post and realized it would help me as well.

The code you posted works like a charm to turn the page footer on and off.
I cant figure out how to make my text print on the second (back) page and
then data on the third page etc. Have you got a solution for this please?

TIA for any help.

Steve

 

[Guest]

I found another post that was helpful so I'm getting closer to the format
that I need for my purchase order report, but I'm still not quite there.

(Search for "Repeat block of text every other page" to find the other post.)

New issue: My report is not printing out the same way it looks in print
preview.

Print preview shows detail section with page footer on pages 1 and 2, then
"terms" report footer only with no page footer on page 3.

When I print the report, the detail section on page 1 goes to the bottom of
page with no page header, pages 2 and 3 print correctly.

Why is the page footer not printing on page 1?

 

[Marshall Barton]

I was reading this post and realized it would help me as well.

The code you posted works like a charm to turn the page footer on and off.
I cant figure out how to make my text print on the second (back) page and
then data on the third page etc.

If you make the page footer invisible on the odd pages, then
you can make it the height of the entire page and put the
text in a label or text box.

 

[Marshall Barton]

I found another post that was helpful so I'm getting closer to the format
that I need for my purchase order report, but I'm still not quite there.

(Search for "Repeat block of text every other page" to find the other post.)

New issue: My report is not printing out the same way it looks in print
preview.

Print preview shows detail section with page footer on pages 1 and 2, then
"terms" report footer only with no page footer on page 3.

When I print the report, the detail section on page 1 goes to the bottom of
page with no page header, pages 2 and 3 print correctly.

Why is the page footer not printing on page 1?

I don't understand what you're saying here. The code I
posted is supposed to hide the page footer on all the odd
pages.

 

[Guest]

Since I still haven't been able to get the full-page "terms" to print on
every even numbered page, I moved it back to the report header and then
suppress the page footer from printing if Page = Pages.

I am still looking for a solution.

 

[Marshall Barton]

Since I still haven't been able to get the full-page "terms" to print on
every even numbered page, I moved it back to the report header and then
suppress the page footer from printing if Page = Pages.

Well, that approach wont work. Why can't you get the full
page using the page footer as I suggested? Maybe all you
need is to make the page footer section taller??

 

[Guest]

Why can't you get the full page using the page footer as I suggested?

Maybe all you need is to make the page footer section taller?

I am able to make the "signature" page footer invisible on the even pages,
but I am still having trouble making only the full page "terms" subreport
print on every even numbered pages, no matter where I put it - in the page
footer or as a 2nd group heading.

 

[Marshall Barton]

I am able to make the "signature" page footer invisible on the even pages,
but I am still having trouble making only the full page "terms" subreport
print on every even numbered pages, no matter where I put it - in the page
footer or as a 2nd group heading.

I need more information.

"still having trouble making only the full page "terms"
subreport print on every even numbered pages"

just doesn't convey enough for me to work with.

Are you saying that the subreport is too tall to fit on the
same page with the signiture text box?

 

[Guest]

I need something similar. Basically, I need a Terms & Conditions template to
print on every even numbered page (i.e., the back page of every "data" page).
On the "data" page, I need to have a signature line at the bottom of the
page. This signature line should not appear on the back Terms & Conditions
page.

This sounds a little confusing, but I just need to make sure that every page
of the purchase order is printed with a signature line at the bottom and the
terms and conditions on the back. One way to do this is to pre-print paper
with the terms and conditions on one side and then just print the PO normally
on the blank front pages. The problem with this is that the printer is also
used for other printing and I would have to move paper in and out. I'm sure
there is a way to do this without pre-printing paper, but I'm having problems
coming up with a solution.

 

[Marshall Barton]

I need something similar. Basically, I need a Terms & Conditions template to
print on every even numbered page (i.e., the back page of every "data" page).
On the "data" page, I need to have a signature line at the bottom of the
page. This signature line should not appear on the back Terms & Conditions
page.

This sounds a little confusing, but I just need to make sure that every page
of the purchase order is printed with a signature line at the bottom and the
terms and conditions on the back. One way to do this is to pre-print paper
with the terms and conditions on one side and then just print the PO normally
on the blank front pages. The problem with this is that the printer is also
used for other printing and I would have to move paper in and out. I'm sure
there is a way to do this without pre-printing paper, but I'm having problems
coming up with a solution.

This is trickier than the other situation because you want
the page footer to be a different size on even and odd
pages.

This can be done only in A2003 (and later?) by using code in
the Page Header section's Format event.

First you need to make the T&C label control and the page
footer section the same height as needed for the Sig label
control. This seems to be required to get the first page to
come out correctly.

The code in the Page Header section's Format event will be
along these lines:

If Me.Page Mod 2 = 0 Then
Me.Section(4).Height = x * 1440
lblBP.Height = x * 1440
lblSig.Visible = False
Else
lblBP.Height = 0
Me.Section(4).Height = y * 1440
lblSig.Visible = True
End If

where x is the height in inches of the page less the top and
bottom margins and y is the height in inches needed for the
Sig label.

This kind of thing is very dependent on what else is going
on in the report so if you have trouble with it, be very
specific in explaining the section, their property settings
and what is unacceptable about the results.