Resizing of MainSwitchBoard

[SeRene]

Hi, I need to resize the MainSwitchBoard so that whenever
it appears, it will fit the Access window perfectly.
Currently, my MainSwitchBoard pops out in different sizes
and it doesnt look that neat for a user interface.

Can someone tell me how to make the size of the
MainSwitchBoard consistent whenever the database is opened
up?

Thanksssss!

 

[James Goodman]

If you look in the On_Current event for the form - Switchboard, add the
following:

DoCmd.Maximize

This will maximize the Switchboard form when it loads...

Alternately you could make sure the AutoCenter is set to true, & then modify
the AutoResize property accordingly...

 

[Peter De Baets]

There are third-party form scaling solutions available that might
help:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site:
http://www.peterssoftware.com/ss.htm

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com