C
Chaplain Doug
Access 2003. How can I programmatically set the computer screen resolution?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.)
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.)
S
Stefan
Douglas J Steele said: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
R
Rick Brandt
Stefan said: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.