MS Access in different screen resolutions

[KPOMalley]

Hi Folks,

I have designed a questionnaire in MS Access using a screen resolution of 1024 x 768. It looks great on my screen but not so hot under different resolutions. How do I set up my database so that the questionnaire will look the same no matter the screen resolution of the individual user.

All help appreciated.....

Access beginner!

 

[mvrp350]

I think of the following:

on the form_load event:
check the users resolution (must be some code avaiable to do this, unfortunately I don't have it present)
If the resolution is different change the height and with of the form and locate all the controls on a proper position.

diadvantage:
needs a lot of coding when you want to cover many resolutions (800x600 to 1920x1440)

Another solution might be the create different forms for different resolutions,
on the startup call a routine that checks the resolution and opens up the according form.

disadvantage:
you'll have to create loads of forms (especially when having multiple forms to be used)

I don't think there's an easy way of doing this.

 

[ghudson]

Design your froms for the lowest resolution your users might have.

There is code within this site that will allow you to change a users resolution but that is not the best practice since you should never alter a users PC settings.

There is code floating around that will modify your forms to fit the resolution but it is not perfect. There are applications floating around that will do the job better but they are not free.

Try searching this forum for more solutions.

 

[shadow9449]

KPO:

Does this help you:

http://www.applecore99.com/gen/gen041.asp

SHADOW

 

[Ukraine82]

Take a look at the attachment.

hth,
Michael

 

[KPOMalley]

Michael,

That's very clever......how would I get that option to pop up on a user opening the data base?

I've designed the database in a resolution of 1024x768.....if the user clicks on 1024x768 option then they'll be no problems with the view. However if the user is set up at 800x600 will your little program reset their resolution or change the settings in the database so that it can be viewed under 1024x768?

As you're probably thinking I'm a real beginner at this so any help is very much appreciated...

KPOM....

 

[Ukraine82]

KPOM,

how would I get that option to pop up on a user opening the data base?

There are couple of ways of doing it, you can either go to tools,startup, and select your form name in Display Form/Page or make a macro for start up be sure to name your macro AutoExec.

Screen resolution will not change automatically to it original size when closing that database. If screen resolution was change in your database be sure to change it back to originally size before closing the database.

hth,
Michael

 

[ghudson]

That would alter the users PC resolution for all programs since it is altering the resolution setting that the user has choosen from their computer. You should not alter a users computer setting. They have set their computers screen resolution to 800x600 for a reason.

Look at it this way... What if your computer screen resolution was changed to one size every time you open Windows Explorer and then changed to another size when you opend Access and changed to another size when you opened Excel just because Bill Gates thought each program would look "better" that way. That would be a lazy way to design a program and one way to tick off the users of your application.

But that is just my opinion. It is your app, do what you want.

 

[Mile-O]

The CD accompanying the Access Developers' Handbook has a couple of modules which are used to resize a form based on the resolution.

 

[mvrp350]

Even worse,
some screens/graphics cards can't handle a higher resolution (think of the older systems)
This would cause the user to be unable to see anything, if the change of resolution is not questioned by the program, how will the user be able to reset the resolution back.
Windows overcomes this problem by asking if a change in resolution should be used, if not it automatically changes back to the original one.

 

[KPOMalley]

Well folks!

It's beginning to look like I might be snookered on this one......

Anyone got ideas on how to help me out......?