PRINTING 2 SIDED PAPER

  • Thread starter Thread starter BRENNON
  • Start date Start date
B

BRENNON

I am trying to figure out how to print pages and always
have each section start on an odd number page. in my
efforts thus far to have this happen, I have been advised
to do the following:

1) Place a page break in the group footer
2) Use the following code in the "on format" section of
the group footer:

If Me.Page Mod 2 <> 0 Then
Me.MyPageBreak.Visible=True
End If

I did this and it appears to work as long as the data
does not spill onto an even number page. If a group ends
on an even numbered page, it still inserts a blank page
behind it causing the next section to start on an even
numberd page as well. Is there a way to have it
recognize that it does not need to insert a page if the
group ends on an even number page?

Any help would be appreciated.

Thanks
--Brennon
 
If Me.Page Mod 2 <> 0 Then
Me.MyPageBreak.Visible=True
Else
Me.MyPageBreak.Visible = False 'This was missing
End If
 
Steve - Thanks for the code addition. However when i
tried this code it still wasnt what i was looking for.
With this code it did not insert a blank page behind the
single page groups. I.e. if group 1 fit on page 1, then
group 2 started on the back of it. I would like it to
place a blank page in so that when printing double sided,
it will print each group on and individual sheet of paper.

Any other thoughts?
 
Back
Top