Re: Setting Report Preview Zoom Level

"Brian" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> Good Morning.
> 
> I'm trying to open a report with a command button and have it open maximized
> and set the zoom level to 150%.
> 
> I accomplished the maximize part with a macro for the OnOpen property of the
> report but can't seem to figure out the zoom part.  I tried using
> SetMenuItem but that didn't work the way I set it up.
> 
> Any help you might provide will be greatly appreciated.
> 
> Thanks in advance.
> 
> Brian

Hello Brian,

Take a look at the following code:

    DoCmd.OpenReport "rptReportNameHere", acViewPreview
    DoCmd.Maximize
    DoCmd.RunCommand acCmdZoom150

You'll notice I'm using RunCommand and NOT DoCmd.DoMenuItem. You
might want to take a look at the RunCommand list. Also, you'll
notice the order in which I set up the preview of the report.

Have a nice day.

Regards, Ray