I am developing a Db in Access 2000. Some users have a 1024x768 resolution, and others have 800x600. How can I set the forms to correspond to the appropriate resolution. It is designed on 1024x768, but when users with a 800x600 resolution look at it, they will miss some of the form. I have enabled scroll bars 'OFF', as I don't really want to use them unless I have to. Can anybody help ?
Many thanks,
-NLP

Litwin's Access 97 Developer's Handbook has some code for changing the resizing your forms based on screen resolution. It's probably in the other versions of his book.

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended).

A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a great article about form scaling in last month's SmartAccess newsletter. Check it out here; http://www.smartaccessnewsletter.com

Also, more info is linked here: http://www.mvps.org/access/general/gen0002.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

I have a module that when added (at least in Access 97) takes care of the resolution problem. You would need to slightly modify it because I have set to do the opposite (take higher to lower resolution). The one thing I have not found is a way to get the Windows Display Font Size (large to small) to change because that can impact the view as well.
If you want the module, e-mail me.


I also have another option from a user that I have not tried yet.

Russ