Opening a form "to fit window" Access 2000

  • Thread starter Thread starter JHB
  • Start date Start date
J

JHB

Hi:

I am now facing the prospect of an Access based program running on
multiple computers, with a wide variety of screen sizes and shapes! Is
there any was to open an Access window (or form) so that it "fits"
the system it is running on? We have long, narrow, high and low
screens and I am haven a bad time finding a format that comfortably
fits them all. Failing a "fit to window" opening, can someone suggest
an alternative approach? This must be something that others have
faced.

No, buying one size for everyone is nott in the cards!

Best

John Baker
 
Hello,

Here is the doc of the GetSystemMetrics function, that will give you the
height and width of the screen, and of its client zone.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms724385(v=....

That being known, you can decide if you can spray the controls on the
surface, or if you have to send them to different tabs.
____________________________________________
JHB wrote, on 26th June 2012 19:22 UTC + 1 :
Click to expand...

Thank you, but once I get all these metrics what am I to do with
them? I have to assume that the users have no clue about how to change
screen sizes, nor should they have to.

Is there no "add in" that will size the window based on the screen
settings?
 
JHB wrote, on 26th June 2012 23:28 :
Thank you, but once I get all these metrics what am I to do with
them? I have to assume that the users have no clue about how to change
screen sizes, nor should they have to.

Is there no "add in" that will size the window based on the screen
settings?
Click to expand...

Well, you have the DoCmd.Maximize command ...

In the .Net platform you have an automatic repositioning of the controls
according to the size of the form, but in Access I am afraid you have to
calculate yourself.

So, count how many controls you have to position, the width/height of
each, how much place it lets you, and divide by the number of intervals.
You do that for width, and then for height.

Do not forget to express lengths in the good unit : according to the
context you can have to use twips, points, centimeters, inches ... This
is another question.

Generally speaking, I develop for the more little screen, and the
controls appear easily on the greater ones.

But you are right that it could be nicer to position the controls on the
whole surface of the form. That is just more work ...
 
JHB wrote, on 26th June 2012 23:28 UTC + 1 :
Thank you, but once I get all these metrics what am I to do with
them? I have to assume that the users have no clue about how to change
screen sizes, nor should they have to.

Is there no "add in" that will size the window based on the screen
settings?
Click to expand...

Another approach can be to define packs of controls, that measure a
certain width and a certain height, and by dividing the dimensions of
the screen you can calculate how many packs you can position.

You spread how many packs you can, and when they are too numerous, use tabs.

I am not sure about what Access can propose you to position a whole pack
at a time, but at least it can simplify calculations.
 
Back
Top