Printing Reports on Duplex Printer - start odd page for record

[Guest]

Hello

I have a very long access report (its about 1700 pages) as part of a
consultants report. There are about 300 different records have varying
numbers of pages (ie from 4 - 9) based on whether particular data has or has
not been entered for that item.

The report will be printed duplex, and I need each individual record to
start on an odd page.

I figured that an 'easy' way to make this happen would be to effectively
print the report individually for each record - is there a way to automate
this? Any hints would be greatly appreciated.
Thanks in advance
Kelly

 

[SA]

Kelly:

Sure, there's a way to automate this.

Assuming that a "record" is started with a Group Header (if not you may want
to add one), then add a page break control to the very top of the Group
Header. Then in the Group Header's On Print event, add code like this:

If Me.Page Mod 2 = 0 Then 'You're starting an even page
Me!YourPageBreakControlsName.Visible = True
Else
Me!YourPageBreakControlsName.Visible = False
End if

That will force the page break to run on even pages, forcing a new page and
not run on odd pages.