Pop Up Form - Placement on the screen

[RupertG]

Recently updated from 2000 to 2007
I use a lot of pop up forms, I used to able to determine their position on
the screen when opening by saving the popup in the position I desired.
Since using 2007 the pop ups randomly reposition themselves to the top left.
How can I have the pop up open where I want it to always.
It's a real pain and reduces my productivity when I have to grab the form
and move it back to where I need it.
The process I use to position a form is to open the form, size it, place it
where I need it, change an element on the form (this causes the save prompt
when closing), close it and save.
These pop ups are being opened by macro commands.

Thank you

BobG

 

[Jeanette Cunningham]

Hi Rupert,
forms can be moved and resized using code -
DoCmd.MoveSize

You can do this on either the Open or Load event of each popup form.

Check out vba help for MoveSize
Here is an example for a system using centimetres

DoCmd.MoveSize 2.5 * 567, 3.0 * 567

That will position the form 2.5 cm from the left of the access window and
3.0 cm down from the top of the access window.
The * 567 converts cm to twips.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[RupertG]

Thanks Jeanette, I've never had to use vba before, maybe now is the time to
learn.

 

[RupertG]

I must be having a good day! I got it to work, again thanks Jeanette ; )