DoCmd.OpenReport acViewPreview

[Guest]

hey all,
i have a form with a button on it that opens my report in preview mode. Is
there a way to open with 100% Zoomed and and certain window size/or
maximized? Right now, by default it opens in Fit view and the window it too
narrow.

thanks,
rodchar

 

[fredg]

hey all,
i have a form with a button on it that opens my report in preview mode. Is
there a way to open with 100% Zoomed and and certain window size/or
maximized? Right now, by default it opens in Fit view and the window it too
narrow.

thanks,
rodchar

If you open the report using an event (like the click event of a
command button):

DoCmd.OpenReport "ReportName",acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom100