center the form

[tmb904]

Anyone have a code for centering the form. I historically will specify in the properties section of the form but it seems my forms is also left aligned on the screen when it is maximized.

 

[apr pillai]

1. Set the following Form Property Values as given below:

Popup = Yes
Min Max Buttons = Min Enabled

2. Add the following VBA Code into the Form Module:

Private Sub Form_Current()

DoCmd.Restore

End Sub

 

[tmb904]

Thank for the feedback APR!

But I may of miscommunicated my goal....

I would like to form to open and maximize. Then I would like the contents of my form to center. Your current solution only centers my form.

 

[boblarson]

Thank for the feedback APR!

But I may of miscommunicated my goal....

I would like to form to open and maximize. Then I would like the contents of my form to center. Your current solution only centers my form.

For that you'll need some pretty intense coding to occur. UNLESS you are using Access 2010 and can use the new forms that they have.