Zoom report preview using VBA?

[John Wirth]

Try as I may, I have yet to discover how to make a preview
view of a report open at 75% size rather than 100%. One
needs some little piece of code in the Report Open event
procedure. I have clicked the zoom buttom a trillion times
and am tired thereof. Help out there?

 

[Marshall Barton]

Try as I may, I have yet to discover how to make a preview
view of a report open at 75% size rather than 100%. One
needs some little piece of code in the Report Open event
procedure. I have clicked the zoom buttom a trillion times
and am tired thereof. Help out there?

Do it right after the code that opens the report:

DoCmd.OpenReport . . .
DoCmd.RunCommand acCmdZoom75

 

[John Wirth]

-----Original Message-----


Do it right after the code that opens the report:

DoCmd.OpenReport . . .
DoCmd.RunCommand acCmdZoom75

THANKS!