Solved Center a Form on the screen with VBA (1 Viewer)

[yamus]

Hello
How can I center an access form on the screen for different display resolutions?
I tried auto center property from design mode but this property centers the form only horizontally
Thanks in advance

 

[isladogs]

There are various methods, all of which give slightly different results.
See this article on my website comparing four methods. Centre Form On Screen - Mendip Data Systems
All code is supplied in the article and with the example apps.

 

[arnelgp]

open form1

 

[isladogs]

Just checked.
The code in the file uploaded by @arnelgp is by Richard Bompuis and is the same as that in Form4 of my example app.
It works well enough for popup forms but is off centre for standard forms.

The best approach will vary depending on the type of form used and whether the ribbon/nav pane are hidden, minimised or'maximised'

 

[yamus]

There are various methods, all of which give slightly different results.
See this article on my website comparing four methods. Centre Form On Screen - Mendip Data Systems
All code is supplied in the article and with the example apps.

Thank you !!

 

[yamus]

Just checked.
The code in the file uploaded by @arnelgp is by Richard Bompuis and is the same as that in Form4 of my example app.
It works well enough for popup forms but is off centre for standard forms.

The best approach will vary depending on the type of form used and whether the ribbon/nav pane are hidden, minimised or'maximised'

I tried it and it worked
Once again, I appreciate the help

 

[yamus]

open form1

It worked well
Thanks a lot !!

 

[isladogs]

On behalf of us both, you're welcome whichever solution you used