Screen Resolution/Size

Question

Hello All,

I just completed working on my database but bumped into a problem with screen sizing/resolution.

Some people in my department have different monitor size/resolution. How do I get the program to open up to adjust to the different monitor size/resolution?

The DoCmd.Maximize did not work.

I am using Access 2010

Thanks!!!!

Answer 1

The DoCmd.Maximize did not work.

Hi,

I'm not sure what you meant by "did not work," but I'll guess you're seeing only a portion of the form on their screen, correct?

If so, this is known issue. The best practice approach is to design forms using the smallest screen resolution your users have. It is easier to scale a form to a bigger screen but not so much going the other way.

If their machines would allow it, I would suggest they temporarily adjust their screen resolution to match yours while using your database.

However, you may still have to redesign your forms to fit the smaller screens until they get a bigger one.

Just my 2 cents...

Answer 2

Yes, I am seeing only a portion of the form on the screen.

Where do I go to change and the redesign the forms to the smallest screen resolution? is there an option Access properties?

What do you think about pop screens?

Thanks!!!

Answer 3

Hi,

Unfortunately, when you design a form, Access uses your screen resolution and remembers it. So, to redesign your forms to their screen size, you can change your screen resolution to match the users' and then move the controls on your form or resize them to make them fit.

Hope it helps...

Answer 4

There is also inexpensive software that can help with this problem:

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

I use it and it seems to work.