Open report at 100% zoom - how?

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

When I have a command button open a report, the type is too small to read.
I want to skip the users having to click on the report to zoom it by opening
it already at 100%.

How do I do that in the code?
I have:

stDocName = "rpt2yrComparison"
DoCmd.OpenReport stDocName, acPreview


Is there something I can add to the end where the helper says I can put:
wherecondition or windowmode?

Thanks in advance,
Rob
 
Rob said:
When I have a command button open a report, the type is too small to
read. I want to skip the users having to click on the report to zoom
it by opening it already at 100%.

How do I do that in the code?
I have:

stDocName = "rpt2yrComparison"
DoCmd.OpenReport stDocName, acPreview


Is there something I can add to the end where the helper says I can
put: wherecondition or windowmode?

Add another line of code immediately after that:

DoCmd.OpenReport stDocName, acPreview
RunCommand acCmdZoom100
 
Back
Top