A97: Print multiple columns on one page

[RonMcIntire]

All:

I am trying to print a booklet (telephone directory) in two columns, with a 1/8" space between columns, on 5-1/2" x 8-1/2" paper format.

How do I print two 5-1/2" x 8-1/2" pages, with a 1" space between pages, on one 11" x 8-1/2" paper?

I have no problem printing two columns in 5-1/2" x 8-1/2" format but I run into trouble when I try to print the two 5-1/2" x 8-1/2" on one page.

Thanks,

Ron

 

[mrsbean]

Hello. I think the answer to your question lies in the printer or printer driver you select to do your printing. If you don't have a really fancy printer which can handle the job, you can try the following:

Go to

http://www.xerox.com

and download a postscript printer driver. The one I selected for this purpose at a previous date was the Xerox WorkCenter Pro (a color printer driver). It comes as a zip file. YOu'll have to unzip it someplace.

Go to your control panel and add a new printer. This printer will print to file rather than to LPT1. When you get to the list of printers, select Have Disk and browse to the folder where you unzipped the Xerox printer driver
files.

Set up your Access report to print to this specific printer. Set the paper size to Statement size. Go into the printer options and set it to booklet format, and expand to fit 8.5 x 11 paper. Print the report. Give it a name -- an uncommon one, because it can take some doing to find the location of the file after it has printed. Give the file name ".ps" extension. Go find your ps file -- it might be in your MyDocuments folder, or it might be higher up in the file structure. I sometimes have to resort to searching for the file name.

If you don't have Acrobat Distiller or a similar product, you can try this. Visit

http://www.ps2pdf.com/convert/convert.htm.

Upload your ps file, and the online site will convert it to a PDF for you. The pages will be in the perfect order for the type of booklet you described.

MrsBean