Search code examples
ms-accessms-access-2010

How do I ensure a pop-up form opens in the centre of the screen?

Background

I have a Access 2010 database and want to create a pop-up progress screen when it does an update of the tables (can take a second to a few minutes).

I can create a pop-up form without any borders etc and display the information I require but I can't for the life of me get the form to open in the centre of the screen.

I have tried setting the "Auto Center" (and "Auto Resize") to true ("Yes") but that didn't seem to have any effect.

Note: I have made the form pop-up by setting "Pop Up" to true.

Question

How can I open a pop-up form in the centre of the screen in MS Access 2010?

Solution

  • when you open the popup form can you do

    DoCmd.MoveSize x, y

    x and y are the x,y co-ords of the top left corner of the form