Zoom report preview using VBA?

  • Thread starter Thread starter John Wirth
  • Start date Start date
J

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?
 
John said:
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?
Click to expand...

Do it right after the code that opens the report:

DoCmd.OpenReport . . .
DoCmd.RunCommand acCmdZoom75
 
Back
Top