form layout, scaling a form and its controls

[Chris Strug]

Hi,

I realise that this isn't going to be answered in a single post but if
anyone can provide any information I'd be very grateful...

To take an example, I have a form containing a listbox with three or four
buttons to its right.

Is it possible (baring some seriously sophisticated coding) to have the
listbox scale when the form is resized. For example, say the user full
screens the form I would like the listbox to expand - along with its columns
to take up the new space on the form. Obviously, the command buttons won't
be resized, just moved.

Any links or book references are greatly received.

Kind regards

Chris Strug.

 

[Henry Smith]

I suggest you purchase a copy of "Access 2000 Developers Handbook" by Ken
Getz and company, published by SYBEX. This 2 volume set is available from
Amazon.com at a discount. In this book Ken Getz provides a very good
discussion about scaling Access forms. Also included is a great routine to
automatically scale forms. The book includes a CD with all the databases
they use in the book and all the neat routines they use too.

The same authors have a new 2 volume set for Access 2002 Developers
Handbook.

Cheers,
Henry