Programmatically Zooming on report

  • Thread starter Thread starter AlCamp
  • Start date Start date
A

AlCamp

When I open a report, I'd like to Zoom to 75% "automagically". (Just when
it opens, I don't care about after that)

It's a report that will be viewed more often than printed, and 100% is just
a bit too big to show all the info. (constant-about 35 lines)

Tried accmdZoom75 on the OnOpen, but got "command not available at this
time".

Any suggestions?

Thanks,
Al Camp
 
Hi

If you create a macro to open your report then add a
second step to the macro with an action "Run Command and
the command line will be Zoom 75%

Rgds
-----Original Message-----
When I open a report, I'd like to Zoom to
Click to expand...
75% "automagically". (Just when
 
Colin,
Thanks... I didn't realize I could initiate the report Zoom from the
"calling" form. Will do, and thanks for the help.
Al Camp
 
When I open a report, I'd like to Zoom to 75% "automagically". (Just when
it opens, I don't care about after that)

It's a report that will be viewed more often than printed, and 100% is just
a bit too big to show all the info. (constant-about 35 lines)

Tried accmdZoom75 on the OnOpen, but got "command not available at this
time".

Any suggestions?

Thanks,
Al Camp
Click to expand...

If you open the report, using code, from a form event:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom75
 
Thanks Fred,
Works fine...
Al Camp

fredg said:
If you open the report, using code, from a form event:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom75
Click to expand...
 
Back
Top