Open an Startup Form in Max and copatible with the resolution of the user's monitor

Mercede · April 22nd, 2009, 11:53 AM

Hello,
I came from .Net programming to Access although it is not my first job in Access but this the most prof. one (In my science). I set up a form as start up form and It should be opened in the Max mod. My Max code uses of Docmd command and work perfect but the problem is some part of the form is unreachable from the users depend on the monitor resolution. How can I fix this problem?
Thank U

boblarson · April 22nd, 2009, 12:28 PM

You will need to do a search (Google for Microsoft Access Resize) for a form resizer. I know there is something out there for free but there is also some pay ones (Peter's Software I think is one of them) which can resize based on screen resolution.

SerranoG · April 24th, 2009, 10:29 AM

Bob's advice about a form resizer is best. However, if it's too complicated for some users, I recommend something I do here.

Basically users in our office are set to one of three settings.

800x600 (for CRT monitors but quickly becoming obsolete with LCD monitors),
1024x768 (for both CRT & LCD),
1280x1024 (for LCD) set at 120 dpi.

When our office starting replacing our CRT monitors with LCD, it quickly became obvious that the lower the setting, the fuzzier the monitor looked. Higher was crisper. However, the higher the setting, the smaller the screen contents and the more people complained that everything was too small to read. That's why the last setting was changed to 120 dpi (or 125% magnification).

Knowing that our office only had these three settings was good because I found code on-line that helps me detect screen resolution. From there, I perfected one form in high resolution, then created low and medium resolution versions of it. No recoding at all, just sizing things on the form accordingly.

When the program opens, an initial form reads the resolution, opens the proper size form, and then closes itself.

The only drawback is that if I make a minor code correction on one form, I have to use search & replace to get it in the other two. If I make a major code change on one form, I have to copy & paste it carefully on the other two. The former is more likely than the latter in my case.

This currently works for me quite well.