I had this problem a year or so ago with an application I'd developed here at work for a group of users who were using a range of screen resolutions. (One user is visually impaired).
To solve this problem you need to invoke Windows API routines. Tricky! However, if you access the SMART Access website (
and subscibe to it (free for 90 days), there's an article in there that I plundered to solve the problem for me. (It contains an Access database to download that can be adapted.) The article is:
"One Size Fits All: Controlling Your Form's Size" by Stuart Kinnear
From memory, it wasn't too difficult to implement, however difficulty is always relative, isn't it? Best of luck!
site, it reads the resolution of one screen and adjusts accordingly. Code is also on the CD that comes with the Access Developer's Handbook, Litwin, Getz and Gilbert
i've tried two or three versions of this, including the one from getz. i have scrapped all because my usual problems are with subforms as boxes (decorative) not working correctly. I'm now a proponent of developing everything on a machine set at 800x600. so far so good.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.