printpreview window sizing

  • Thread starter Thread starter mg
  • Start date Start date
M

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!
 
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
 
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?
 
Back
Top