How can I center Access 2007 switchboard opened to full screen?

[JAGster]

I am creating a database in Access 2007 for multiple users, some with very limited experience with access. I am using a customized switchboard to make it more user-friendly.

I have the switchboard opening to full screen (covers all of the access window) and it is centered on my laptop but when I open the database on a different computer, different monitor size and resolution, it is not centered.

Is there anyway to have the switchboard centered, no matter the monitor size/resolution when opening to full screen?

[ADezii]

You can always make sure that a Form is Centered regardless of a User's Screen Resolution, but the Code is a little complex, and I do not believe that the Form can be Maximized. If you wish to see how this can be done, just let me know.

[NeoPa]

Have a look at the AutoCentre property of the form.

[JAGster]

ADezil, I appreciate the offer on the code but I feel it necessary to have the switchboard opened to full screen for security and to avoid overwhelming users unfamiliar with Access.

NeoPa, The AutoCentre property is set to yes, but the form is not centered.

Thanks for the ideas. Any others will be greatly appreciated.

Regards, JAGster

[ADezii]

@JAGster: Kindly explain...

I feel it necessary to have the switchboard opened to full screen for security and to avoid overwhelming users unfamiliar with Access.

[JAGster]

ADezii,
I am concerned that inexperienced Access users will be confused/intimidated by the Access menus on the ribbon. I am also concerned about securing the database from tampering, inadvertent or otherwise.

I read a little bit of Rabbit's post on Securing a Database in Access and will look into the methods descrbed there for securing the database.

I am very interested in learning how to center forms, regardless of screen resolution. Thanks, JAGster

[ADezii]

How, exactly, are you Opening the switchboard to Full Screen?

[JAGster]

I got this from Jim Doherty's reply to an old post

min max buttons none
Borderstyle none
popup yes
navigation buttons no
Recordselectors no
scrollbars neither

In the on load event entered the code - DoCmd.Maximize

[JAGster]

The form is triggered to open from the Autoexec macro.

[NeoPa]

So, if it's opening in Full Screen mode, how is it centred or not centred? Surely that is something that's relevant only in restored mode?

[ADezii]

@NeoPa:
Post #11 says it all from what I can see. It is not a matter of the Form itself being 'Centered' since this makes little sense in its 'Maximized' State. It appears to be a problem of centering the 'Controls' within this Form for various Screen Resolutions. A Command Button on a Maximized Form that is Centered on the Screen, will no longer be once the Resolution is changed. Technically the Controls on the Form need to be Scaled as well as Repositioned which can be done, but will be a little complex.

@JAGster: Is this correct?

[NeoPa]

ADezii:
Post #11 says it all from what I can see.

Post #11 is the one you just posted ADezii :-S

I couldn't find any post that even seemed to indicate that, but if that's true, we have a much clearer question to answer. We'd need details of these controls of course and how they fit on the form generally. With that the situation is certainly handlable. I'm sure either of us could help with that.

[ADezii]

@NeoPa: Make that Post #8! (LOL)

[JAGster]

ADezii, You are correct, I misstated what I really needed to know how to do. Scaling and repositioning the controls for any resolution is what I need to do.

The controls are command buttons that are opening sub-switchboards. The sub-switchboard forms have command buttons to return to the main switchboard, close and exit the database, import files to populate tables, open split-forms with subforms, etc. I've attached a copy of the database with sensitive data removed.

I am in the process of changing the look and feel of the sub-switchboard forms and the other forms to be more like the main switchboard. My end goal is to either have all forms open full-screen with the controls scaled and repositioned or to have just the main switchboard and sub-switchboards open full screen with the controls scaled and repositioned and the other forms open centered on screen no matter the resolution (if they can open in front of the sub-switchboard form that is open full screen). I want the access window always hidden no matter what form(s) are open.

[ADezii]

Unfortunately, I can only use Access 2002 at this time. Kindly Convert a Copy of the DB (Forms only) to Access 2002, so that I can have a really good look at the Forms and Controls contained within.