Need page eject after each copy of a two-sided report

J

Jerry

I have a 99 page MS Access 2000 report that is being sent
two-sided to a Cannon IR 5000 printer. When printing
multiple copies of this report, page 1 of the second copy
prints on the back of page 99 of the first copy. How can
I force a page eject at the end of each copy?
 
M

Marshall Barton

Jerry said:
I have a 99 page MS Access 2000 report that is being sent
two-sided to a Cannon IR 5000 printer. When printing
multiple copies of this report, page 1 of the second copy
prints on the back of page 99 of the first copy. How can
I force a page eject at the end of each copy?
Click to expand...


Add a PageBreak control near the bottom of the report
footer. Next, make sure that you have a control somewhere
on the report that refers to Pages. Then use code in the
footer section's Format event:

pgBreak.Visible = (Me.Pages Mod 2) = 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a duplicate page to a report 2
in two sided printing how do you force next page to next odd page 1
Need to print Cover Sheet for report. 11
Two sided report 2
Duplex no longer working 2
Creating duplicate copy of report on same page 0
How do I get report to print this way? 1
How to print a double sided report - Access 97 2

Top