Opening report with set zoom

[Basil]

Hiya,

I have a report that gets opened from a form. When opened
in VBA I get it to maximise the report automatically. Is
there a way that I can get it to adjust the zoom level
to 'fit in window'? I am using Access 97.

Any ideas most appreciated.

Thanks,

Baz

 

[Jim/Chris]

I use the following in Access 2000
After the following line:
DoCmd.OpenReport stDocName, acPreview
Insert
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow

Jim

 

[John Spencer (MVP)]

Try using

DoCmd.RunCommand acCmdFitToWindow

 

[Basil]

Thank you both very much - works a treat from the form,
but if the code is written in the open report code it
says "Cannot run command accmdfittowindow at this time".
Don't know why, but it is manageable.

Many thanks.

 

[Rick Brandt]

Thank you both very much - works a treat from the form,
but if the code is written in the open report code it
says "Cannot run command accmdfittowindow at this time".
Don't know why, but it is manageable.

Yeah, that's always been a drag. You can put the Maximize command in the
Report's Open event but not the Zoom or FitToWindow.