Control Report Zoom

[Burt]

Hi,

Is there a way of controling the zoom percent(%) of a
report when you are opening the report for preview using
code?

I notice it always comes up 100%. Is it possible to have
it come up 150%.



Burt

 

[mrwizard2903]

Hi Burt,

I used the northwind database for my example code.

<code>
DoCmd.OpenReport ReportName:="Catalog", _
View:=acViewPreview
DoCmd.RunCommand acCmdZoom150
<\code>

HTH
Jeffrey R. Bailey

 

[Burt]

Jeffrey,

Thanks,

I'm going to play with it now. I'm also assuming that the
150 in the statement could be a variable. No need to get
back to me. I'm going to try a lot of configurations.

Thanks again,

Burt

 

[Bruce M. Thompson]

I'm going to play with it now. I'm also assuming that the

150 in the statement could be a variable. No need to get
back to me. I'm going to try a lot of configurations.

Actually, the "150" in the statement...

DoCmd.RunCommand acCmdZoom150

....is a portion of a constant name, not a value. if you need to control the zoom
beyond the standard increments offered using the Runcommand method, see the
following page at The Access Web:

Custom Zoom in Reports
http://www.mvps.org/access/reports/rpt0020.htm