How do you change the screen size when opening a .mdb

[michaelpotts]

hello,

I have created a database, I created it on a screen that was 1024 by 768. Now that I have 8 users, using this, they all choose to have different display settings, so if one of my users has a 800 by 600, the database displays a lot bigger than what mine would be. Does anyone know if there is a way of when opening the database the display changes to 1024 by 768 and when it closes it changes back to what it originally was. (sorta like playing games huh)

Thanks
Much appreciated.

 

[Peter D]

Some users might not appreciate your application changing their screen resolution settings.

There are third-party form rescaling solutions available that might help:

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

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

For more informmation, there are some great articles about form scaling in the December 2000, and May 2001 SmartAccess newsletter. Check it out here: http://www.smartaccessnewsletter.com

Hope this helps,

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