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

  • Thread starter Thread starter L Mehl
  • Start date Start date
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
 
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
 
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...
 
Back
Top