Open report at 100% zoom - how?

[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

 

[Dirk Goldgar]

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

 

[Rob]

Thank you.

Rob

Add another line of code immediately after that:

DoCmd.OpenReport stDocName, acPreview
RunCommand acCmdZoom100

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)