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/