Opening report with set zoom

  • Thread starter Thread starter Basil
  • Start date Start date
B

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
 
I use the following in Access 2000
After the following line:
DoCmd.OpenReport stDocName, acPreview
Insert
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow

Jim
 
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.
 
Basil said:
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.
Click to expand...

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.
 
Back
Top