Grow/Shrink Forms with Screen resolution

Does anyone know of a way to make the Forms in an Access DB grow or shrink to fill up the Access window regardless of screen resolution settings?

I want the form to look the same on 640x480 and  800x600 with large or small fonts selected.

If this is not feasible, what is the most common screen resolution to design for?  I would guess 800x600 with small fonts.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You are talking a big task!

However, an easier way around it might be to create a form for each resolution, and then use an API to find out what the resolution is...

But as stated, every control would have to be adjusted!

I agree, 800×600 is probably the most common.

This question has been asked many times. To see previous answers to this question type in "resolution" in the search text box on your screen. Make sure "topic area" is checked and not "everything".
If you check most of the questions regarding this issue, they will suggest that you purchase software from  There is a big article on them in Access/SQL/VB advisor this month (2/2000 issue) and I suggest you check it out.

I have never heard a bad word about fms and they seem to have a good reputation.  fms Sizer is US$ 70 for a single developer license but includes royalty-free distribution.

Brian's suggestion is pretty interesting.  I would follow that route if funds dictate. The problem is you'd have to keep all those forms synchronised during development to make sure they were exactly the same (outside of resolution).

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

If you go to the Microsoft Access site, they have a downloadable component that does what you are asking.

Here's a description from their site (they also have this for MS Access 97):

Use ShrinkerStretcher to dynamically scale your Microsoft Access 2000 forms to fit any screen resolution, font setting, or display scheme. Develop Access applications without concern for your end user's display settings.

The site is at:

Hope that helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
There is also something in the "Access Developper Handbook", vol 1, Ken Getz, Paul Litwin, Mike Gilbert, Sybex.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.