[AccessD] Control size of Report Preview window

Dan Waters dwaters at usinternet.com
Thu Aug 24 16:52:45 CDT 2006


Hi Fred,

One thing you can do is to maximize every report each time it is opened in
preview:

------------------------------------------------
Private Sub Report_Close()

    DoCmd.Restore
    
End Sub
------------------------------------------------
Private Sub Report_Open(Cancel As Integer)
    
    DoCmd.Maximize
    
End Sub
------------------------------------------------

You'll need to include the Restore method because maximizing any object
maximizes all the objects.  When you restore, all objects go back to their
original size.

This also resolves the issue of trying to anticipate different monitor
settings.

HTH,
Dan Waters
ProMation Systems, Inc.

-----Original Message-----
Subject: [AccessD] Control size of Report Preview window

Is there any way to control the size of the report preview window?

Runcommand acCmdZoom (10 ... 200) controls the size of the printing in the
window but doesn't control the size of the window.

Manually sizing the window and pressing the save button "kind of" works, but
the window gets progressively smaller as the front end is repeatedly
compacted and repaired. Also, when it's moved to a machine with a lower
resolution monitor it further shrinks.

Is there something using twips (like there is for forms) that I can read,
save & apply so the report preview window will be the same inch/cm
dimensions on all monitors, regardless of their resolution?




More information about the AccessD mailing list