Hi all,

Is there anyway to set the absolute position of a form on the screen so that it opens in the same place. Auto centre doesn't seem to work and its becoming annoying. I have numerous different sized forms and would like each to open at a set point depending on the size of it.

At the moment the forms are opening seemingly whereever they feel like it, regardless of where i closed them up in design view or moved them once i re-enabled movable.

If looked through all my library of books of vba and access and can't find anything there

You want to use the Move property of the form. On the Form_Load event, try this code:

Me.Move Left:=1440, Top:=2880

The Move command uses twips, and there are 1440 twips per inch. So this line moves the top left corner of the form 1 inch left and 2 inches down from the inside corner of the Access window.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

thanks i'll give it a go and post back if get any problems