Page Breaks Start Each Section on Odd Page Number

[Reen-a-been]

I have a report that is over 500 pages long but I need to put in page breaks
that separate the "sections" - each new section needs to start on an odd page
number - sometimes leaving a blank page between.

I have tried a few of the suggestions that were previously posted on here
but nothing seems to work. I either get a loop that just runs forever trying
to set up the report or I get a blank page on every even page number....

Does anyone have any suggestions???

 

[Marshall Barton]

I have a report that is over 500 pages long but I need to put in page breaks
that separate the "sections" - each new section needs to start on an odd page
number - sometimes leaving a blank page between.

I have tried a few of the suggestions that were previously posted on here
but nothing seems to work. I either get a loop that just runs forever trying
to set up the report or I get a blank page on every even page number....

How is the report setup to separate the "sections"?

Normally, there would be a group header section with a
PageBreak control at the top of the section and the
section's Format event code would use a line of code to make
the page break visible on even pages:
Me.pgBreak.Visible = (Me.Pages Mod 2 = 0)