print odd pages or even pages

[Russ]

I'm trying to make a booklet style report and would like Access to
print the odd numbered pages, and then I can put the paper back in the
printer and hopefully print the even numbered pages backwards on the
other side. Any way of printing like that?

 

[Russ]

Hey, folks... don't let the 'printing in reverse order' scare you. If
anyone knows how to pring just odd or just even pages I could sure use
that all by itself.

 

[John Spencer]

The only thing I can think of is to try using something like Clickbook.

http://www.bluesquirrel.com/products/clickbook/

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Russ]

Sounds like it might work John, but I've only got 3 or 4 pages to
print on the Access report. I noticed that MS Word will print
odd/even pages, but Access won't do it. Maybe export to an rtf file
then get it from word there. Too bad Access can't do that directly.

I was hoping someone had developed some code to get by this
shortcoming.

 

[trevorC via AccessMonster.com]

Get a better printer, they can do that now. (Big ones anyway) Or print each
page to a pdf file then use pdf viewer or word to print them.

 

[trevorC via AccessMonster.com]

Or you could try this -

make boxes to cover all report sections, change thier color to white
foreground and white back color. Then set them to Visible = false and not
transparent.

Now use some code to get the page number, if it's odd then make the boxes
visible (Just leaves a blank page, i use this to not print on used labels)
Just swap it around for the Even pages.