Report Zoom Level

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I would like to change the zoom level that my reports
start at each time they are opened. Is there a property
I can set of some VBA code I can use to do this?

Thanks,
Chuck
 
Chuck said:
I would like to change the zoom level that my reports
start at each time they are opened. Is there a property
I can set of some VBA code I can use to do this?
Click to expand...


It's not very elegant, but you can use a line of code
immediately following the OpenReport statement:

DoCmd.RunCommand acCmdZoomXXX

where acCmdZoomXXX can be any one of:
acCmdZoom10
acCmdZoom100
acCmdZoom1000
acCmdZoom150
acCmdZoom200
acCmdZoom25
acCmdZoom50
acCmdZoom500
acCmdZoom75
acCmdFitToWindow

You may or may not want to use this as well

DoCmd.Maximize
 
Thanks Marsh but it's giving me an error when I try
this. It says "The command or action 'Zoom200%' isn't
available now". I tried using the zoom command in a
macro too and I get the same message. Any thoughts?

Thanks,
Chuck
 
Thanks Marsh but it's giving me an error when I try
this. It says "The command or action 'Zoom200%' isn't
available now". I tried using the zoom command in a
macro too and I get the same message. Any thoughts?
Click to expand...

Where did you put the line of code? It doesn't work within the Report
itself.
 
Thanks Marsh but it's giving me an error when I try
this. It says "The command or action 'Zoom200%' isn't
available now". I tried using the zoom command in a
macro too and I get the same message. Any thoughts?
Click to expand...


Did you put the DoCmd.RunCommand on the line immediately
after the DoCmdOpenReport line?

You didn't actually use the %, did you?

I guess I have to see more details before I can figure out
what you're doing differently from what I do.
 
If you are using a macro that opens your report as a part
of the macro sequence, you can add a line after when the
report opens. The action is Maximize.

This may produce undesirable results overall, but it may
work for you.

HTH
 
Back
Top