There is no built-in way to do what you want (although I don't know about
the most recent version of Access). If at all possible you should design
for the 800 x 600 resolution. Although I haven't tried it, I would think
that if you split your database you could have different versions of the
front end, although that is extra work now and when you update. There are
some resizing utilities. Here are links and tips I have copied for two of
them:
1. Download an MDE file from the Developer's Handbook web site. You can then
reference that MDE in your application to use the resize code.
http://www.developershandbook.com/
2. Purchase the Developer's Handbook for your version of Access. In my
opinion the book is WELL worth the money. Not only do you get the resize
code, but a wealth of other information, code, and database samples. Go to
the same site listed above for more information.
3. Peter's software has a resizing utility at:
http://www.peterssoftware.com/ss.htm
I have used the first one. It works OK at resizing a form designed for 800
x 600 to the smaller resolution, but it is some effort to implement it. A
search for Access resize or something of the sort should produce some more
information.
