capturing and setting screen resolution in VBA

[msnews.microsoft.com]

Is there a way to capture the user's screen resolution, and then set it to a
different value in VBA?

I have tried unsuccessfully to get all of my users to set their monitor
resolution no lower than 1024 x 768, but there are some holdouts that insist
on keeping theirs at 800 x 600. Some of them still have 17" monitors, and
with that limited amount viewing area, it's difficult to design the forms
small enough that they don't have to scroll around to view the entire form.

If it were possible to capture and reset the screen resolution, I would
first check to see if they're at 800 x 600, then reset it to 1024 x 768.
When they exit the Access application, I would restore it to 800 x 600.

Is there a way to do this in VBA?

Thanks in advance.

Paul

 

[Maurice]

I think it's best to program at the lowest resolution being used. If you want
to resize you will be checking constantly which resolution is being used.
What if a user switches to a different resolution during there work process.
I personally use an external display connected to my laptop. I have three
monitors which range between 15" and 21". My advice use the 800 x 600
resolution. That way nobody has to scroll through anything...

just my 2 cts.

 

[Tony Toews [MVP]]

I have tried unsuccessfully to get all of my users to set their monitor
resolution no lower than 1024 x 768, but there are some holdouts that insist
on keeping theirs at 800 x 600. Some of them still have 17" monitors, and
with that limited amount viewing area, it's difficult to design the forms
small enough that they don't have to scroll around to view the entire form.

Maybe those users have poor eyesight and should be getting 19" or 21"
LCD monitors. They're cheap enough these days.

If it were possible to capture and reset the screen resolution, I would
first check to see if they're at 800 x 600, then reset it to 1024 x 768.
When they exit the Access application, I would restore it to 800 x 600.

http://support.microsoft.com/kb/q148395/ for reading the screen
resolution. I'm sure there is code at vbnet.mvps.org.

However I would never muck with users settings. That is a rather
arrogant attitude that will upset users.

I don't use Outlook but do run it occasionally for testing code and
such. And it just ticks me off when software such as Outlook takes
over my settings for my other software.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[roger]

these two website have some good code for sizing forms and the access window
itself, Can't help you with forcing a screeen resolution though

www.lebans.com
www.mvps.org/access/forms/

 

[Paul]

My thanks to Maurice, Tony and Roger for their observations and suggestions.

Based on what you have said, I'm persuaded that it's not a good idea to
adjust the user's screen resolution, even it it were possible.

Thank you, gentlemen.

Paul