Form size vs screen resolution

[TTSKevin]

Hi all!

Im currently planning a db to be used at my work. I'll be running it BE/FE, and there will be numerous users using alot of different computers and display sizes.

Guess you'll already guessed where this is going...
Ive been searching alot around to figure out how to design my db to get it it to run smooth on different screnns and different resolutions.

I was thinking of designing it running my computer at 1024x768, since the chances are not too many is running lower resolution than this.

But form sizes in access is defined using metric values instead of pixel values, and how do i know what a form will look like on a different size screen running the same resolution as i am?
I mean, if i run my 24" screen at 1024, and designs the main menu form to ocupy whole work aeria with the program maximized, what wold this be like on a 17" running the same resolution?

Wold it fit perfectly, and look the same as on my screen, only smaller ofcourse, or wold the actual size in mm be applied, so that there will be scroll-bars?

Another thing ive been thinking of is making a complete set of forms for each resolution, and making a dialog for for the FE installation where the user selects the resolution they want. Using macros the corresponding forms is kept, the rest is deleted, and the forsm is then renamed to mach the correct names in the database.

As you see, english is not my first language, and i dont know if i get my message across. I hope you see what i mean.

Thanks!

Kevin

 

[ajetrumpet]

kevin,

i've been pondering this same thing for quite a while. good information here:

http://www.access-programmers.co.uk/forums/showthread.php?t=183775

btw, the autoresizing of a form is a good thing. so i wouldn't worry too much about this issue.

 

[morglum007]

Use Jamie's module to do so. Will do automatically for every form, and will work in access 2007 too quite smoothly.

http://www.jamiessoftware.tk

I have applied it succesfully in my huge data base with no problems. Also use the Peter's window manipulation module (v3.1) in order to do litte things with maximization and so (in conjunction with the above's).

Enjoy

 

[missinglinq]

I've also used Jamie's hack without problems. You've already figured out the main thing, which is that you need to develop the app in the lowest possible resolution you'll need. This and all other resizers I've come across all work better in sizing up than in sizing down!

Good luck!