Johannes030399
asked on
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.
Thanks.
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.
Thanks.
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 www.fmsinc.com. 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).
Wes
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).
Wes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The actual ShrinkerStretcher URL is http://officeupdate.microsoft.com/2000/downloadDetails/ss9demo.htm?s=/downloadCatalog/dldAccess.asp
There is also something in the "Access Developper Handbook", vol 1, Ken Getz, Paul Litwin, Mike Gilbert, Sybex.
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.
Brian