Report Preview Window Size

BrettM

just a pert, "ex" to come
Local time
Tomorrow, 05:55
Joined
Apr 30, 2008
Messages
134
I would appreciate any suggestions how to set explicit window position and size for a report preview in the way you can for a form?

Regards Brett
 
Here's a DB that does a pretty cool job of positioning a report. Sizing it can't be that much tougher.
Cheers,
 

Attachments

After a little experimentation I have a very simple answer.

in Report Properties...
set Auto Center to Yes.
set Auto Resize to No.
set Pop Up to Yes.

and in the line immediately following your DoCmd.OpenReport statement put...
DoCmd.MoveSize , , width, height (I use 13300 and 11000 on an XGA monitor)

If you want to specify the exact start position on the screen use
DoCmd.MoveSize left, top, width, height (0,0 is the left,top of screen)

if you want the start position to be relative to the active window and not the screen then set Pop Up to No.

Regards Brett
 

Users who are viewing this thread

Back
Top Bottom