How can i Move My Form to my left of my screen on Load (1 Viewer)

[nick07]

Im trying to load a form to be bottom right of my screen and on other screen sizes too, how can i accomplish this result in access 2016

 

[moke123]

Form.Move method (Access)

Office VBA reference topic

learn.microsoft.com

 

[Pat Hartman]

Turn off the autocenter property and when the form opens, it will open in the position where it was when you saved it in design view. If that doesn't solve the problem, then you can use code to move the form around after it opens.

 

[The_Doc_Man]

OK, you got two viewpoints so far. I'll step behind the scenes.

To figure out what you have to work with,

How can I find the width of the parent window in MS-Access

I'm trying to force an MS-Access form to take a certain position relative to the right edge of the main window (actually I want to center it, but I can see also wanting to dock it to one side or an...

stackoverflow.com

From there, remember that the "anchor point" in Access is the top left corner, which is to say (top=0, left=0). So you can set the form's position to the far left as 0, but to set it to the bottom of that area, you must take the bottom as determined from the parent window size and subtract the form's height to place the form vertically at the bottom of the window.

 

[Luis Fernandez]

You must also understand that the forms open within access and not anywhere.
Therefore you must maximize access to cover everything and position your forms as desired.
If what you want is to show other applications, you will have to modify the access form in me.app and other ways.

You can also make the access form not visible, but that is more difficult.

 

[CJ_London]

You also need to set overlapping windows and/or your forms need to be popups

 

[sarfarazali]

In Access 2016, use the "Anchoring" feature to position the form in the bottom right corner and ensure it adapts to different screen sizes.

 

[theDBguy]

In Access 2016, use the "Anchoring" feature to position the form in the bottom right corner and ensure it adapts to different screen sizes.

Hi @sarfarazali. Welcome to AWF!

Isn't Anchoring only for Controls and not Forms? How exactly do you anchor forms to the screen?

 

[Luis Fernandez]

DoCmd.RunCommand acCmdAppMaximize
This maximizes access, then you can maximize or position each shape as needed.
or/and acCmd

acCmdAnchorBottomLeft	616
acCmdAnchorBottomRight	618
acCmdAnchorBottomStretchAcross	617
acCmdAnchorStretchAcross	611
acCmdAnchorStretchDown	613
acCmdAnchorStretchDownAcross	614
acCmdAnchorStretchDownRight	615
acCmdAnchorTopLeft	610
acCmdAnchorTopRight	612

DoCmd.Maximize
also
Use vba or seting form
Me.AutoCenter = xx
Me.AutoResize = xx
Me.WindowHeight = xx
Me.WindowLeft = xx
Me.WindowTop = xx
Me.WindowWidth = xx