Connecting Tech Pros Worldwide Forums | Help | Site Map

Multiple User Resolutions Causing Headaches With Forms

Newbie
 
Join Date: Nov 2007
Posts: 1
#1: Nov 13 '07
I am about to fall over!

I developed a MS Access program that is distributed throughout multiple offices in my company. The program is working great, but many of the users must have poor vision and have their resolution set extremely low (as low as it goes!). Needless to say, this has caused all of my beautiful form to look gigantic on their screens and cuts off most of the content. I have searched unsucessfully for a solution to the problem and came here as a last resort. Can anyone help me with some type of module or code that will resize Access 2003 forms specific to the individual end-user's screen setting?

Please help!

NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,722
#2: Nov 14 '07

re: Multiple User Resolutions Causing Headaches With Forms


That depends what you mean really. Typically one designs the form to fit the lowest common denominator.
In your case I would try maximising the form on open, then the user can scroll where necessary. Not ideal I know, but that's why the design is so important.
Expert
 
Join Date: Apr 2007
Posts: 192
#3: Nov 14 '07

re: Multiple User Resolutions Causing Headaches With Forms


Quote:

Originally Posted by NeoPa

That depends what you mean really. Typically one designs the form to fit the lowest common denominator.
In your case I would try maximising the form on open, then the user can scroll where necessary. Not ideal I know, but that's why the design is so important.

Lezenky,Reddick and Getz did some good work on this. I searched for a link, and lo and behold, there is one in thescripts. Try this link for more help
http://www.thescripts.com/forum/thread211349.html
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,214
#4: Nov 14 '07

re: Multiple User Resolutions Causing Headaches With Forms


Quote:

Originally Posted by interplan

I am about to fall over!

I developed a MS Access program that is distributed throughout multiple offices in my company. The program is working great, but many of the users must have poor vision and have their resolution set extremely low (as low as it goes!). Needless to say, this has caused all of my beautiful form to look gigantic on their screens and cuts off most of the content. I have searched unsucessfully for a solution to the problem and came here as a last resort. Can anyone help me with some type of module or code that will resize Access 2003 forms specific to the individual end-user's screen setting?

Please help!

What you need is Resizing and Scaling code for Forms, Controls, and Sections which will make them independant of the Screen Resolution, and which will also enable them to display properly at any Resolution. Are you proficient in VBA and understanding Classes?
Reply