MONITOR "AUTO SCREEN-SIZING" OF ACCESS 2000 FORMS

[Hiccup]

HELP OUT THERE!!

I sized my Access 2000 Forms on a 19" monitor, but when I view them on a smaller monitor, of course, they're too large and the scroll bars must be used to view the entire form.

Are there properties or settings available in Microsoft Access to automatically change the size of Forms to fill the monitor's screen regardless of the monitor size?

Ed "Hiccup" Hicks
ed.hicks@wcg.com

 

[beetee]

Auto resizing is an interesting topic, which is why there is, AFAIK, no intrinisic support for it (even in the visual C++ programming environment).

A program would have a difficult time deciding how controls should be moved, what they should line up with, or which ones can grow or shrink.

One answer is to design your forms to fit on the smallest resolution, and to allow a few controls to grow or shrink when the form is resized.

To do this, you use the OnResize event. You can determine the size of your form using the Me.InsideHeight and Me.InsideWidth properties, then set the Top, Left, Width, and Height properties of your controls as you see fit.

It tends to become a fair amount of code.

 

[MichaelRed]

Use advanced search in these fora (Ms. Access and VB). There sre several posts with extensive discussions of and examples for accomplishing the 'scaling' Some of them discuss / illustrate approaches & techniques which, while they are (internally) complex, are relatively simplistic in implementation (at least at the user level), requiring only the inclusion of the (presented) modules, declarations (API calls) and procedures and a very few lines of code in the various forms to accomlish the tasks.

As with many issues, the examples may not accomplish exactly what you intend, they should, however, at least provide a reasonable perspective for your further consideration, and perhaps a basis for you to make a decision on wheather to persue the topic or to manually revise the forms to suit the user base.

If you decide to manually revise the existing forms, I would furthewr suggest that you review the "tab" control. I often use this simple device to organize complex forms and minimize the user's (simultaneous) exposure to large numbers of controls. It can accomodate as mamy controls as may be otherwise included on a form (minus 1) and condense the display 'footprint' to reasonable sizes for current generation monitors. Virtually all code presently involved will transport directly (some small issues re tab sequencing), so actual 're-design' primarily consist of cut and paste of existing controls to the selected tab(s)/"pages" of the tabstrip control, although you may also choose to re-arrange the controls on the individual tabs/pages for esthetic purposes.


MichaelRed
m.red@att.net

Searching for employment in all the wrong places