How to Set/Reset Screen Resolution

[Guest]

Access 2003. How can I programmatically set the computer screen resolution?

 

[Douglas J Steele]

You can, but should you?

Don't forget that your users might be using other applications at the same
time that they're using yours.

Don't forget that your users might have vision issues that require them to
use a specific resolution.vbn

If you were to write an application that changed my screen resolution, I'd
quickly scrap it.

Far more appropriate, in my opinion, is have your application resize itself
to accomodate the current resolution.

If you do have a legitimate need to change the resolution, check out what
Randy Birch has at http://vbnet.mvps.org/code/enums/enumdisplaychange.htm

(Obligatory warning: Randy's site is aimed at VB programmers. Since there
are significant differences between the controls available in VB forms and
in Access forms, some of his samples will not port directly to Access. I
haven't looked that closely at this specific example, so I can't comment as
to whether it'll port unchanged. However, the underlying code should give
you an idea of what needs to be done.)

 

[Guest]

Far more appropriate, in my opinion, is have your application resize itself
to accomodate the current resolution.

Douglas,

I have the same problem on my work. 12 out of 13 colleagues are using at
least 1024 x 768. Just one uses the major 800 x 600.

In your reply you said something about to let resize your application.
So, my question is how it is done. Is this an automatticly thing or is
there VBA involved.

Many thanks
Stefan

 

[Rick Brandt]

Douglas,

I have the same problem on my work. 12 out of 13 colleagues are
using at least 1024 x 768. Just one uses the major 800 x 600.

In your reply you said something about to let resize your application.
So, my question is how it is done. Is this an automatticly thing
or is there VBA involved.

Many thanks
Stefan

In general you just have to design your app to support the lowest resolution
setting that any user might have. There are utilities and/or code routines
that can resize a form based on the user's resolution HOWEVER; these are a
lot better at making forms larger than they are making them smaller. How
well they work also depends on the types of objects you have on your forms.
For example subforms and tab controls do not resize as well as other
controls.

Software at the link below used to have a free demo version if you want to
play with the idea.

http://www.peterssoftware.com/ss.htm

For just one user I would be tempted to lobby for them to get a bigger
display.