Switchboard Size and Position Control 1

[JohnHarkins]

When the database wizard creates a switchboard menu it works satisfactorily for knowledgeable users. I'd like to be able to:

Keep the switchboard menu centered in the workspace whenever it's restored (from minimized).
Keep the switchboard menu at a constant size, permitting minimizing but not maximizing.
Not automatically maximize the switchboard menu after another window, such as a form, is maximized and subsequently closed. In other words, if a user decides to maximize a form to fill the screen, upon closing that form, the switchboard menu should return automatically to its original dimensions (centered on the screen and with fixed dimensions).
I suspect it takes some VBA code to force this rigor... can you help?

Thanks,

John

John Harkins

 

[Lightning]

Use the Docmd.Restore method in the Switchboard's On Activate event. (Or you could use the Got Focus event).

HTH

Lightning

 

[mattpearcey]

Trying to work this out, as i have a similar problem. But i cannot find the On Activate option. Is this the On current or On Open? And, do i have to do this in VB view or can i get around it through the expression builder? Thank you for your help already.

Matt Pearcey

 

[petermeachem]

Well if the switchboard border is set to none, then you won't be able to minimise or maximise it and it will stay happily in the middle of the screen behind whatever other forms you have.
So just make the border none? Peter Meachem
peter@accuflight.com

 

[mattpearcey]

Good idea. I have just had a play with it and i prefer now to make it Border size Thin, then it has a border, but it does not allow it to be made to a different size. Thank you for your help already.

Matt Pearcey

 

[Lightning]

Matt

Sorry to take so long to get back to you!

The On Activate event for the Form is visible on the Form's property sheet.

In Design view, select the form, open the Property sheet, click on the Event tab. The On Activate and On Deactive events are about halfway down the list, immediately after the On Close event.

From the online Help file for the Activate event:

When you first open a form, the following events occur in this order:
Open Þ Load Þ Resize Þ Activate Þ Current
When you close a form, the following events occur in this order:
Unload Þ Deactivate Þ Close

HTH

Lightning