Zoom size in print preview 2

[Sponge]

On a form i have a print preview button (created by the wizard) which works okay but previews the report at zoom=100%. I want to be able to preview the report at zoom=fit. I have tried a few different commands in the code of the button but still no joy.
Any suggestions that will help will be gratefully received.
Thanks. [sig][/sig]

 

[PaulF]

try
With DoCmd
.OpenReport "Report Name", acViewPreview
.RunCommand acCmdFitToWindow
.Maximize
End With


PaulF [sig][/sig]

 

[Sponge]

Cheers PaulF for that, it worked a treat.
Thanks. [sig][/sig]

 

[Paul7905]

Question regarding this technique ~ I tried it myself and it works great ~ However, when closing the previewed report and going back to the access form from which the preview was invoked, the screen/form stays maximized and the user is forced to click on the "restore" control box on the form to restore it back to it's "normal" size.

Is there a way to automate this restoration??

thanks
Paul [sig][/sig]

 

[PaulF]

place a
DoCmd.Minimize
in the Close Event for the Report


PaulF
[sig][/sig]