How to center form

[aspfun]

I use Access 2010.
How to open a form and make it at center of screen every time?

 

[Catalina]

Go to the Form Properties, on the Format Tab set Auto Center to Yes.

Catalina

 

[aspfun]

I tried it but did not work. Is there any code to manage it?

 

[missinglinq]

AutoCenter only centers Horizontally, and actually interferes if you try to manually position a Form, which is the only way to center a Form, on both axies, short of figuring out the positions,in twips, for the left and top, and setting this every time the Form opens. Tried that a few times, but just too much hassle, IMHO!

This method has worked for me for years:

If using Access 2007/2010

• Click on the Office Button (Larger button, Top/Left)
• Click on Access Options (Bottom/Right)
• Click on Current Database
• Set Document Window Options to Overlapping Windows
• Click on OK
• Close and Re-open the Database

Then, for all Versions, in Form Design View

1. Set AutoCenter to No
2. Set AutoResize to No
3. Size and Move the Form to desired position
4. Click on Save
5. Close Form without doing anything else!

You might have to tweak this a little, by repeating Steps 1-5, to get it to the exact, desired position.

Linq ;0)>