Here, I found this by doing a search on "Zoom Preview" on this forum.
You could have done the same. Anyway, here is what I found.
If you open the report from a command button event on a form, you
can
use:
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdZoom150
If yiou also wish to make sure the report opens Maximized, just add
DoCmd.Maximize to the above.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/