Pixels 800 by 600

[Guest]

I have an access application that when I run it on my machine it looks
perfect. My screen is 800 by 600 pixels. I have a couple people who have it
their screens set diffent and the window looks so small on their screen but
they wont change their pixels. Is there code in access that I can force the
screen to 800 by 600 for all users.

Thanks,

Steven

 

[John Spencer]

Yes, there is code to do this. HOWEVER, I wouldn't recommend it. Most users
will get very, very upset if you change their screen resolution or other settings.

Are the users complaining about the size? If so, you can run code to resize
your objects on the screen.

You have several options. Firstly, you could recreate your forms suitable for
different resolutions, and then use a startup form that will open the correct
form after checking for the user's resolution - there is code for detecting the
resolution here -

http://support.microsoft.com/?id=148395

Alternatively, you could resize your forms using a utility (note that this
appears to work best when you have designed at a low resolution, ie 800x600,
and convert to a higher resolution, such as 1024x768). Firstly, there is
ShrinkerStretcher, a utility from Peter de Baets, available at
http://www.peterssoftware.com . Secondly, there is code in the Access
Developer's Handbook by Litwin/Getz/Gilbert, and they have put an MDE (for both
A97 and A2K) on their site at http://www.developershandbook.com