Form Sizes (1 Viewer)

[popen]

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

 

[llkhoutx]

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.

 

[Peter D]

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

 

[russi]

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