How Do i Resize Forms/diff users have diff resolutions

[Guest]

In Access 2003, when used on different computers the sizing of the forms
vary due to different users resolution setting for their screen display
How do you make the forms resize to look right in each of their respective
displays

 

[Bill (Unique as my name)]

1. VBA. Run the code when you click a button on the form.
2. Set up forms for different resolutions and switch among them when
you click a button on the form.

 

[Jason Martin]

http://support.microsoft.com/kb/113458/en-us

Use code in above link to determine resolution in an OnOpen event of an
AutoExec form when db opens then hide/unhide appropriate buttons for
additional forms. For example, create a form called Main Menu and have two
buttons. One button opens a form sized for VGA and the other for SVGA.
Hide the one that's not appropriate when the code above returns the user's
resolution.

Hope this helps.

- Jason

 

[Rick Brandt]

In Access 2003, when used on different computers the sizing of the
forms vary due to different users resolution setting for their
screen display How do you make the forms resize to look right in each
of their respective displays

Design for the smallest resolution of your users and then don't worry about it
on the higher resolution displays. People buy higher resolution displays so
they can see MORE stuff, not bigger stuff.