Re: Setting Report Preview Zoom Level

Ray -

That worked perfectly!  Thanks for your help.


"Ray" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "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