Form Dimensions for different screens?

[Bob Vance]

Where can I locate the form dimensions that will fit a 19in 24in wide in
screen
I have worked out from my 17in 26cm Wide and 17cm Height!

 

[Allen Browne]

Bob, you would need to make API calls to ask Windows about the screen
resolution, but IMHO this is not a productive thing to do. If yuo want to
proceed anyway, search for the VB calls here:
http://vbnet.mvps.org/
Mostly, they work in VBA without modification.

You may need to consider:
- the number of monitors the workstation has

- the resolution and orientation of each monitor

- o/s dot-per-inch setting (may not be the Windows default)

- the size of the main Access window the application is in. (It may not be
maximized, and may be spread across multiple monitors)

- whether the form is a child window of Access, or a popup (outside the main
Access window.)

- whether A2007 is using tabbed forms or overlapping windows

- for overlapping child windows, whether the form is mazimized within the
Access window, and if not whether it is placed and sized within the Access
window (or scrolled so partially outside the Access window)

Once you get all that sorted out, you now have string of other issues to
sort out if you want to scale your application to fit. I suggest you look at
Chapter 8 of the Microsoft Access Developers Handbook (Ken Getz et al), for
code to resize. You may find that this code is out of date. I don't know how
well it copes with multiple monitors of different resolutions and
orientations, 64-bit Windows, and all the issues above. It does, however,
address the problems of trying to scale controls that contain other controls
(such as a tab form or option group or subform.)

Then when you have done all the hard work to get this sorted out, you're
going to have to deal with the anger of users (like me) who detest any
developer who thinks I bought a big screen just so you can fill it up. I
certainly won't use your application at any price if you scale it so that it
spreads out vertically to fill up my entire portrait-orientation monitor.

 

[Bob Vance]

Thanks Allen, I was thinking of putting some check boxes on my main form so
as you choose the monitor setting you had, then when you selected a form it
would look at what check box was true to show the bigger form display, this
program is a stand alone so only 1 size monitor was needed, is this stupid?,
or do I just buy shrinker/stretcher....Regards Bob

Bob, you would need to make API calls to ask Windows about the screen
resolution, but IMHO this is not a productive thing to do. If yuo want to
proceed anyway, search for the VB calls here:
http://vbnet.mvps.org/
Mostly, they work in VBA without modification.

You may need to consider:
- the number of monitors the workstation has

- the resolution and orientation of each monitor

- o/s dot-per-inch setting (may not be the Windows default)

- the size of the main Access window the application is in. (It may not be
maximized, and may be spread across multiple monitors)

- whether the form is a child window of Access, or a popup (outside the
main Access window.)

- whether A2007 is using tabbed forms or overlapping windows

- for overlapping child windows, whether the form is mazimized within the
Access window, and if not whether it is placed and sized within the Access
window (or scrolled so partially outside the Access window)

Once you get all that sorted out, you now have string of other issues to
sort out if you want to scale your application to fit. I suggest you look
at Chapter 8 of the Microsoft Access Developers Handbook (Ken Getz et al),
for code to resize. You may find that this code is out of date. I don't
know how well it copes with multiple monitors of different resolutions and
orientations, 64-bit Windows, and all the issues above. It does, however,
address the problems of trying to scale controls that contain other
controls (such as a tab form or option group or subform.)

Then when you have done all the hard work to get this sorted out, you're
going to have to deal with the anger of users (like me) who detest any
developer who thinks I bought a big screen just so you can fill it up. I
certainly won't use your application at any price if you scale it so that
it spreads out vertically to fill up my entire portrait-orientation
monitor.

 

[Bob Vance]

Thanks but does not support M A 2007

Or an alternative you might look for is here.

http://jamiessoftware.tk/resizeform/rf_download.html