Report to Preview as if user clicked View | Zoom | Fit To Window

L

L Mehl

Hello --

Is it possible to add code to a report so that it opens as if the user
clicked
View | Zoom | Fit To Window?

Thanks for any help.

Larry Mehl
 
F

fredg

Hello --

Is it possible to add code to a report so that it opens as if the user
clicked
View | Zoom | Fit To Window?

Thanks for any help.

Larry Mehl
Click to expand...

Sure, if you open the report from a command button on a form.

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
 
L

L Mehl

Thanks Fred.

Larry

fredg said:
Sure, if you open the report from a command button on a form.

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
Click to expand...
 
Top