How do I change the size of the preview report popup box?

S

sci1

When I code an event to Preview Report, I want the report to display full
screen, not a partial screen. How do I do this?
 
F

fredg

When I code an event to Preview Report, I want the report to display full
screen, not a partial screen. How do I do this?
Click to expand...

Don't know what you mean by 'full screen' or 'partial screen'.
Any way, one of these runcommand's or Maximize is probably what you
are looking for.

In the event used to open the report:

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

Look up the other various Zoom sizes available in VBA Help.
 
Top