set an Access 2010 Form to open in a specific location

Hello experts,
I would like an Access 2010 form to always open in a specific location on the screen. How do I accomplish this?
Joanne BaileyDatabase AdministratorAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
I like to use the Load event. Only fires once for each form, but you could use the Open event as well.

Private Sub Form_Load()

    Me.Move 1440, 1440, 7500, 7500
   
End Sub
0
 
Dale FyeCommented:
Consult the help on the "move" method of the form.
0
 
Joanne BaileyDatabase AdministratorAuthor Commented:
On Load? On Current? On Open?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
hnasrConnect With a Mentor Commented:
You may incorporate a settings table for forms.
In Load /Open event search for the forms record and use the respective values in Move statement.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Not that some techniques to do this will place the form on the screen based on the users monitor resolution...
So the form may not appear in the *exact* same location on each users computer, ...but may remain in the same "relative" position...
0
 
Dale FyeCommented:
You could also store it in a table: tbl_User_Form_Pref:

UserID
FormName
FormLeft
FormTop
FormWidth
FormHeight

I rarely see a need for this level of detail, but I do use a similar technique with datasheets, because everyone likes to see their datasheets formatted a little differently.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.