printpreview window sizing

[mg]

i used VBA to launch print-preview(acViewPreview) of a report from my form,
but i cant see how to control how the preview-window will appear.
.....currently, it has no min/max controls, and when the report is magnified,
the window doesnt stretch out with it. it also won't allow me to
drag-and-stretch the sides.

any ideas how i can call the report preview with a the window maximized or
something?

thanks!

 

[Paul Shapiro]

I put a line of code into each of the Report's report_activate and
report_deactivate events.

Private Sub Report_Activate()
DoCmd.Maximize 'Maximize the preview window
End Sub

Private Sub Report_Deactivate()
DoCmd.Restore 'Restore normal window size
End Sub

 

[mg]

thanks.
but, is there a way to point to each of the reports inside the VBA code so i
dont have to do this by hand in all the reports?