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

  • Thread starter Thread starter Jerry
  • Start date Start date
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?
 
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
 
Back
Top