Form/Switchboard: fixed size

[Guest]

Hello:

I need to fix the size of my switchboard so that:

If:
1. minimized
2. maximized
3. on open
4. etc.

it's always the same size.

In design view it is a certain size, but I find it that often when I open a
different form then switch back to my switchboard, it's maximized. I need to
avoid that.

How does one keep it fixed, by option or code is fine, I"m comfortable with
both.

Thanks as always!!
pepe

 

[Van T. Dinh]

Use

DoCmd.Restore

in the Form_Activate Event.

If you don't want the user to re-size the Switchboard manually, set the
BorderStyle to None or Thin.

You can also annoy the hell out of the user to re-size the Form to whatever
it was by using the Form_Resize Event.

 

[Guest]

Van that worked just fine. Thank you.

Use

DoCmd.Restore

in the Form_Activate Event.

If you don't want the user to re-size the Switchboard manually, set the
BorderStyle to None or Thin.

You can also annoy the hell out of the user to re-size the Form to whatever
it was by using the Form_Resize Event.