Force New group to start on an odd numbered page

[Guest]

I have a report in which I start a new group on a new page and reset the page
number to 1 for each new group. However, I now want to use the duplex feature
on my printer. How can I force each new group to start on an odd numbered
page so that the last page of one group is not on the back on the first page
of the next group. ie force a blank page if the group ends on an odd numbered
page

 

[MA]

I have a report in which I start a new group on a new page and reset
the page number to 1 for each new group. However, I now want to use
the duplex feature on my printer. How can I force each new group to
start on an odd numbered page so that the last page of one group is
not on the back on the first page of the next group. ie force a blank
page if the group ends on an odd numbered page

test if is pair page
and in case not jump of one page
--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it

 

[Guest]

Sorry , I do not understand your solution.
What object do I test?
How do I force a page break?

 

[Marshall Barton]

I have a report in which I start a new group on a new page and reset the page
number to 1 for each new group. However, I now want to use the duplex feature
on my printer. How can I force each new group to start on an odd numbered
page so that the last page of one group is not on the back on the first page
of the next group. ie force a blank page if the group ends on an odd numbered
page

Add a PageBreak control named pgEject at the bottom of the
group footer section. Then use some code in the footer
section's Format event:
Me.pgEject.Visible = (Me.Pages Mod 2 = 1)

You could probably use an analogous approach in the group
header if you don't have a group footer.

 

[Guest]

Thanks Marsh, your solution worked great.
While I have your attention, do you know how to set the Binding option for
duplex printing. I am trying to create a landscape flipbook and have set the
following: Reports![Vending Driver Day List New].Printer.Duplex =
acPRDPHorizontal
Reports![Vending Driver Day List New].Printer.Orientation = acPRORLandscape
However I have to set Binding to "Long Edge" to create the flip effect. Do
you know how this can be done?

 

[Marshall Barton]

While I have your attention, do you know how to set the Binding option for
duplex printing. I am trying to create a landscape flipbook and have set the
following: Reports![Vending Driver Day List New].Printer.Duplex =
acPRDPHorizontal
Reports![Vending Driver Day List New].Printer.Orientation = acPRORLandscape
However I have to set Binding to "Long Edge" to create the flip effect. Do
you know how this can be done?

Sorry, No, I have neverhad a duplex printer, not have I
tried to create a flipbook. Try posting your question to a
new thread.