Auto For Access

[Guest]

Hey All,
Is there a way to set an access database to auto adjust settings in order to
appear correctly on each users screen? I have a few users who have their
desktop set to an extremely low resolution leading to a zoomed and blocky
access display. Will they have to adjust this themselves or is there a better
way. Please explain where to put and how to use any code. I am a VBA rookie.
Thanks, Adam

 

[Allen Browne]

There's not a nice solution for this.

If you buy the Access Developers Handbook by Getz et al (Sybex), the chapter
on Forms (cpt 8 from memory) has code that shows how to resize the form and
its objects based on the screen resolution of the user.

But I find that clunky, and I hate the very concept that some developer
thinks he has the right to enlarge all his text so it fills up my entire
screen. I did not buy a high res to give him that option.

So, ultimately you define the mimimum resolution your application will run
at, and design for that. Used to be 800x600. These days I find must people
accept 1024x768 as a minimum, and accept that they need to upgrade their
monitor if they have less than that.