Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Print Odd/Even Pages only (in a report)

Status
Not open for further replies.

chaoita

Programmer
Jun 23, 2000
2
US
I need to print odd/even pages for an address book (uses both sides of a paper) I figured out the formula <br>Me.page mod 2&lt;&gt;0 or Me.page mod 2=0 to determine odd or even pages. <br>I use this formula on every print section so every time i use print preview/open my report, it correctly displays/supresses the odd/even page.<br>Example, for odd, it displays: page 1 with data, page 2 is blank, page 3 is filled with data, page 4 is blank, page 5 with data, so on and so on.<br>Now when i print, it prints out the blank pages as well.<br>I want to streamline it so it will only print odd or even pages (no blank pages) .&nbsp;&nbsp;Is there a way to do this?<br>Do I need to create a modal dialog box, or a customized toolbar? How do I get the customized toolbar to accept vb, because macro doesn't accept variables.<br><br>Any help would be appreciated.<br><br>Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top