Using docmd.openreport

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

When I'm using docmd.openreport (as part of the code behind a command
button on a form) is there a way to have the report open zoomed to
100%. Right now it opens to 'Fit' and it's just not the best view for
me.

Karen
 
When I'm using docmd.openreport (as part of the code behind a command
button on a form) is there a way to have the report open zoomed to
100%. Right now it opens to 'Fit' and it's just not the best view for
me.

Karen
Click to expand...

Sure.
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCMDZoom100
 
Karen,
Add this code to your OpenReport...

DoCmd.OpenReport "YourReportName", acViewPreview
DoCmd.RunCommand acCmdZoom100
 
Back
Top