Setting Report Preview Zoom Level

#1

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

#2

"Brian" <someone (AT) microsoft (DOT) com> wrote

Quote:

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

#3

Ray -

That worked perfectly! Thanks for your help.

"Ray" <raycait (AT) excite (DOT) com> wrote

Quote:

"Brian" <someone (AT) microsoft (DOT) com> wrote

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Setting Report Preview Zoom Level

comp.database.ms-access comp.database.ms-access

Setting Report Preview Zoom Level - 11-12-2003 , 08:55 AM

Re: Setting Report Preview Zoom Level - 11-13-2003 , 05:34 AM

Re: Setting Report Preview Zoom Level - 11-15-2003 , 05:48 PM