Open Report to "Fit" window

[spectraflame]

Currently my report button brings up the report in maximized mode. Some of the users have asked if it would be possible to have the report displayed in "Fit" mode or fit to page. They are getting confused on which "X" or close button to use and are closing out of the entire database instead of the report.

I know that this is silly, but you have to know my users. If this is not really doable, is there a way to size the report output window to a particular size?

Matthew

 

[Stubby Holder]

try this:

DoCmd.OpenReport "rptMyReport", acViewPreview
RunCommand acCmdFitToWindow

hope it helps!

 

[spectraflame]

Thanks Stubby that was what I was looking to do.

Thanks again,
Matthew