Opening a form "to fit window" Access 2000

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
 
J

JHB

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 :

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?
 
G

Gloops

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?

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 ...
 
G

Gloops

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top