Link to home
Start Free TrialLog in
Avatar of davcos
davcos

asked on

remember a forms location on the screen

Where can I change the setting so that a form will open in the same location it was when I closed it?  If I edit the form, move the location on the screen and save it, it will then always open in that location.  What I would prefer, is that it reopens in the spot where I last closed it.
Avatar of danishani
danishani
Flag of United States of America image

Check below thread out, solution provided by Dirk Goldgar:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/4fb49579-25c8-47b6-a9a2-5f53b4429e33/

Hope this helps,
Daniel
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Easy. User the MoveSize Method:

The MoveSize method carries out the MoveSize action in Visual Basic.

expression.MoveSize(Right, Down, Width, Height)

Example .... and all values must be in Twips ... 1440 Twips/Inch

Private Sub Form_Load()
    DoCmd.MoveSize  1440*0.5, 1440*0.5, 1440*3, 1440*5
End Sub

mx
Avatar of davcos
davcos

ASKER

I guess I was thinking you could store the location "on close" and restore that location "on open".  Am I thinking about this incorrectly?
Are you talking from an end user perspective or you as a developer when working on design ?

mx
Avatar of davcos

ASKER

As an end user.  We have several users of the database and they all use tables to do different tasks and would like the tables to come back where they were previously.
Avatar of davcos

ASKER

form
OK ...  

First ... be sure that Auto Center and Auto Resize are set to No.
Then ... before closing the Form - position it where desired, then File>>Save.  This will effectively 'save' the location of the form.  Next time when opened, it s/b in the same place.

mx
Avatar of davcos

ASKER

That's the problem, you would have to edit the form each time you wanted to save a new position.  We just want it to always open where we last closed it.

Thanks for all the response!
No no ... nothing to edit.
Basically .. it's File >>Save.

A one time setting ... be sure that Auto Center and Auto Resize are set to No.

mx
Avatar of davcos

ASKER

I have Auto Center and Auto Resize set to "No", but once I save the form, it always opens in the same position as I last saved it.  I'm trying to get the form to remember where it was the last time I closed it, and open in that location the next time.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davcos

ASKER

That will work!  Thank you!