form resize

[Rob]

I have several forms that I have created to be utilized in a multi user
environment. Any and all users may have different screen resolutions. I
have designed these forms so that they fit perfectly and come up perfectly if
the screen resolution is 1024 x 860. However, any other resolution the
screens don't fit correctly and may cause the users anxiety. Is there a way
to program the database so that the form size changes based on the screen
resolution or some way change the screen resolution automatically to a
specified size. Any help is always appreciated.

Rob

 

[Douglas J. Steele]

There's sample code to do this in Access Developer's xx Handbook by Litwin,
Getz and Gilbert et al (where xx is whatever's appropriate for the version
of Access you're using). You can learn more about their books at
http://www.developershandbook.com/

They've also produced an MDE version of the code that you can download from
http://www.developershandbook.com/downloads.htm and use in your application.

Another option is to purchase ShrinkerStretch from Peter De Baets
http://www.peterssoftware.com/

There's also code at http://jamiessoftware.tk/resizeform/rf_download.html
but I don't really know anything about it.