Print 2 pages of report side by side

rpadams

Registered User.
Local time
Today, 08:05
Joined
Jun 17, 2001
Messages
111
Does anyone know how to set up a report so that by default it prints to the screen at 75% with 2 pages side by side? I'm really looking for some VBA that fires when I hit my "Print Report" button on my form.
 
I guess I meant to say print "preview"

What I'm looking for is a way to automatically show the print preview screen display as two pages and 75% in the same way you can manually do it by clicking the 2 page icon and the 75% scale from the Access report toolbar.

My rationale is that I often give my users a quick preview (via a print preview button) of the report so they can check it out before wasting paper. The screen preview can be condensed (even "to fit" or less than 75%) but the actual print button might be at 100%, one per page.
 
Thanks -- just what I needed

This was just what I wanted. I had tried something similar from the open event of the report itself and kept running into just the problem you described. I just hadn't thought to use the line in the open report method on my calling form. Where does Microsoft document all these twists and turns where something works one place and not another? The cryptic "function not available here" is not too helpful. I sometimes feel I am programming by trial and error -- and wasting a good deal of time in the process.

I added the line DoCmd.RunCommand acCmdZoom75 in the same place, as you suggested.
 

Users who are viewing this thread

Back
Top Bottom