screen resolution

[Guest]

Hi,
Is it possible to write a code that changes the screen resolution when
opening an access project and then restores it to the previous when closing.
If not, is it at least possible to read the current screen resolution from
Ms-Access.
I would like to offer the best possible form layout to the users of my
access databases, but they all use different screen sizes and/or resolutions.
If I can't change their screen resolution, I would like to be able to
identify it and choose to open the form that fits best with their screen size.
Thanks for your help

 

[John Spencer]

I would NOT change the resolution. The users have set the resolution the
way they want it - perhaps for very good reasons such as visual problems.
If you mess with it they are liable to be upset

Your idea of using forms suitable for different resolutions,and then using a
startup form that will open the correct form after checking for the user's
resolution is one way to solve the problem- 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

It's been awhile since I checked either of those sites so the links may not
work.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks. I have not tried it yet, but it's exactly the type of info that I
was looking for.

 

[Rick A.B.]

Christian,

You might search out a free ware program called Resolution Changer. I
haven't used this with MS Access but have with terminal software and
it does exactly what you want, sets screen resolution to specified
size then resets it when you exit the program.

 

[Guest]

Many thanks Rick.
I will try that out for my personal use or in very controlled environments.
For the databases that I distribute to other users, I would rather go for
John's suggestion and incorporate the code as a module in the application for
2 reasons:
- That will make the database simpler to install. I try to avoid too many
addins, and the risk of breaking the code if one of the components is
missing. Also, some companies are very strict about the softwares that they
allow on the users' computers.
- I would rather avoid affecting the screen resolution that someone else
has selected on their computer. The only situation when I would change
someone else's setting is when I can change them back to the original
settings when my application window is deactivated (lost focus) and not just
on exit, and that seems a bit weird to do with the screen resolution, because
the screen would have to be re-ajusted (blank for a few seconds) everytime
the user would switch between tasks.