Resizing screen display

[RealGomer]

I created a database at 1024x768 resolution. Some folk who use this db have
their resolution at 800x600. Needless to say, a large portion of the display
(forms) is now hidden. You have to scroll to see everything whereas at 1024
everything was visible. Is there a way to get Access 2000 to resize the forms
so everything is visible at 800?

 

[Rick Brandt]

I created a database at 1024x768 resolution. Some folk who use this
db have their resolution at 800x600. Needless to say, a large portion
of the display (forms) is now hidden. You have to scroll to see
everything whereas at 1024 everything was visible. Is there a way to
get Access 2000 to resize the forms so everything is visible at 800?

There are VBA routines and utilities you can acquire that will dynamically
resize forms. However; they are a lot better at making forms larger than
their original size than they are at making them smaller. Much depends on
the objects in your forms. Subforms and TabControls for instance usually
get buggered up. It also gets dicey when various font size settings are
involved.

Most developers with this issue just design for the lowest setting that they
want to support. I have maximum form dimensions that I know still fit on an
800 by 600 display and I just don't design forms any larger than that and
yes it often does feel like your developing with one hand tied behind your
back.

 

[Joe Fallon]

Access 2002 Desktop Developer's Handbook (Getz, Litwin)
There are 3 classes to handle screen resolution in the book.
They are worth the price of the book alone.
Plus you get the book!

 

[BruceM]

There is a free utility here:
http://www.developershandbook.com/
This is the site for the Developer's Handbook that Joe mentioned. I have
used the utility, with decent results. Laptops with 1024 x 768 resolution
unfortunately sometimes do not display well at 800 x 600, making it difficult
to use the larger resolution for very long. To get around this I have noted
the size of the largest rectangle that will fit on an 800 x 600 screen. I
just temporarily add that rectangle on a 1024 x 768 screen and keep the
design within its boundaries. I agree that it is rather a pain, but such
measures are the only choice.