Page Breaks

[Jamie A Miller]

I have a report that I am working on in Access 2003. Is there anyway to
create a break similar to Word, where I can have it be an odd page break? I
have different heading which force a page break before it, but if it is on an
odd page, I need the new page to be and odd one, creating a blank even page
inbetween them, or simply not printing the blank even page. Is there an easy
way to do this? I do not do well with Event Procedures or Macros, so if I
must use one on these, please be VERY specific as to what I need to do.

Thanks!!

 

[Marshall Barton]

I have a report that I am working on in Access 2003. Is there anyway to
create a break similar to Word, where I can have it be an odd page break? I
have different heading which force a page break before it, but if it is on an
odd page, I need the new page to be and odd one, creating a blank even page
inbetween them, or simply not printing the blank even page. Is there an easy
way to do this? I do not do well with Event Procedures or Macros, so if I
must use one on these, please be VERY specific as to what I need to do.

Add a Page Break control named pgSkip to the top of the
header section. Then add a line of code to the header
section's Format event procedure:
Me.pgSkip.Visible = (Me.Page Mod 2) = 0

To get to the event procedure so that you can enter the line
of code, double click on a blank area in the header section.
Then look down the section's properties list (Event tab) and
click on the OnFormat property. Then click on the builder
button [...] in the right margin. This will open the
report's module and position the cursor in the procedure so
you can enter the above line.