Getting pop-up form to center on monitor

[isladogs]

I'm somewhat confused by your lengthy (but incomplete) reply so apologies if I'm missing the point here

Form positions and sizes are measured in twips and cannot currently exceed the integer limit of 32767 (approx. 22.75 inches)
Your code will give unpredictable results if you try to exceed that

I have various articles that may be helpful including:

Automatic Form Resizing 1

Use automatic form resizing (AFR) to ensure that forms and their controls are automatically resized and repositioned for any screen size & resolution. It can also be used to add a zoom feature to Access forms

www.isladogs.co.uk

Extend Access across Multiple Monitors

This example app provides code that allows the Access application interface to be extended across two or more monitors. It can be used to show different forms or reports on separate monitors simultaneously or to simulate having a very large monitor

www.isladogs.co.uk

Accurately Move Forms & Controls

This article demonstrates how to accurately move forms & controls based on the various units of measurement used in Windows applications (pixels, points and twips) together with the little known and undocumented VBA Wizhook function

www.isladogs.co.uk

Control Application Interface

This article discusses how the Access application interface can be controlled including hiding the navigation pane, ribbon or the entire application interface.

www.isladogs.co.uk

I suggest you limit the height of continuous forms to be slightly less than the monitor height
I prefer the code in Form 3 but that won't solve your issue.

 

[InstructionWhich7142]

Apologies, I gave up on that fragment by the look of it but didn't notice it was still hiding at the end there! Thanks for taking the time anyway.

The Twips limit makes sense for the issues I'm seeing, but how does Access handle a 3 monitor setup that's wider than 22 inches? Is that why I'm seeing negative twips returned by me.Windowleft? I'm not explicitly trying to exceed 22 inches, I'm just trying to get forms to appear in relatively sensible places, e.g. if a user opens a large form and drags it to a second window, then clicks a button that causes a second small popup form to appear I'd like it to be somewhat near where they're currently working, rather than center it on a different monitor miles away,

I had wondered about trying to grab the mouse position and putting the form there but it comes back to the "how do I handle the negative twips" issue?

 

[Uncle Gizmo]

There's an alternative method which may prove useful "Sticky Forms" forms that stay where they are put ....

Sticky Form Builder – Nifty Access

www.niftyaccess.com

 

[InstructionWhich7142]

Having read into this a bit more I'm concerned the large 2 and 3 screen setups will cause issues with the TWIPS limits so I'm not sure I want to go the sticky forms route