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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access report 0
docmd.openreport wont work on different pc 3
parameters using docmd.openreport 7
Setting Zoom Level 2
Print preview zoom 100 doesn't work 2
Make Command Button print Specific Report 6
“This Action requires an Object Name argument†Error Message 1
Runtime Error 6 Overflow 1

Back
Top