Access 2003, Making forms auto size to size of window

[sellert]

Is there a way to make a form automatically size to match the size of the window.

In other words, If a form is designed to show up in the middle of the monitor, and user expands the window to full size, I would like for the form to adjust the size and spacing of controls to fill the space so the form also expands. Much like a webpage can.

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.

 

[kjv1611]

Not sure, but I don't think this is a simple thing in Access. You'd have to either program it yourself, or find a plugin online - not sure if one is available or not.

--

"If to err is human, then I must be some kind of human!" -Me

 

[SoCalAccessPro]

It's not simple. You have to scale every object on the form, as well as the form itself.



Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[SeeThru]

There is a form resizer you can buy - I think PHV has a link to it.

Doing it yourself would be a major undertaking. However, resizing just one control (like a subfom) to use more of the remaining space is more achieveable.

SeeThru
Synergy Connections Ltd - Telemarketing Services

 

[jamaarneen]

Hi sellert,

Here is a link, where you can download for free a little access file, with some functionality about resizing form.

the code in there might help you. I hope so. just let me know...

Ja

 

[ajrimmer]

You might also look at this form resizer:

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

Works OK, though there are limitations - notably with tabbed forms.

 

[sellert]

Thank you all, I knew it wouldn't be easy. I feel a new Function or more coming on.

Thanks,
SELLERT

If I'm not learning I must be coasting. If I am coasting I must be going down hill.