Access screen resolution, resizing - 07-07-2005 , 07:34 PM
I've created an access program that's used by 5 people.
Two of the individuals have lower screen resolutions that makes it
difficult to utilize the program as written
Is there any way to reset the resolution when the program opens and
when set back upon exiting?
It looks like there may be some freeware out there that provides a
module that will do this. Anyone have any experience with these, or
any other suggestions on how to solve this.
Re: Access screen resolution, resizing - 07-07-2005 , 07:46 PM
You should never change user settings. Yours will seldom be the only program
that'll be running, so your change will impact more than your application.
As well, some users may require the lower resolution, due to vision
A far more palatable solution is to put in code to resize your forms to
match your users' resolution.
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
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
There's also code at http://jamiessoftware.tk/resizeform/rf_download.html
but I don't know anything about this specific code.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"mar10" <mar10a (AT) yahoo (DOT) com> wrote
Re: Access screen resolution, resizing - 07-07-2005 , 08:02 PM
Re: Access screen resolution, resizing - 07-08-2005 , 10:16 PM
A couple more options to add to the list Doug already provided:
(Watch out for any line wrapping on that link)
Access Junkie - MVP
"mar10" wrote in message:
news:1120782854.356801.7020 (AT) o13g2000cwo (DOT) googlegroups.com...
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----