Open report in Fit to window view

A

Ashley

I would like to open report in FIT to window view. Anyone
know how to code it?

Thanks
 
R

Rick Brandt

Ashley said:
I would like to open report in FIT to window view. Anyone
know how to code it?

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow
 
M

Marshall Barton

Ashley said:
I would like to open report in FIT to window view. Anyone
know how to code it?


I swear this question gets asked at least once a day. I'm
sure that a Google search of the newsgroups for
Access report fit window
will find a thousand matches.

To save you the trouble of looking for it, use this sequence
on your form's preview button's Click event:

DoCmd.OpenReport . . .
DoCmd.RunCommand acCmdFitToWindow
 
Top