How to print ood/even pages

[chaoita]

I need to print odd/even pages for an address book (uses both sides of a paper)<br><br>I figured out the formula 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><br>Now when i print, it prints out the blank pages as well. I want to streamline it so it will only print odd or even pages (no blank pages). 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks!

 

[DougP]

I would create form and put a button on it, then you can write VBA code to your hearts content.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.