If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Position Cursor
When I click on Add a form from the switchboard, how do I tell it where to
place the cursor. When my form loads, I would like to cursor to be in the fieldname 'Sign In Date' Thx |
#2
|
|||
|
|||
Position Cursor
|
#3
|
|||
|
|||
Position Cursor
On Fri, 26 Mar 2010 16:19:01 -0700, Summing multiple fields on a form
t.com wrote: When I click on Add a form from the switchboard, how do I tell it where to place the cursor. When my form loads, I would like to cursor to be in the fieldname 'Sign In Date' Thx Put VBA code or a macro in the form's Load event to setfocus to the desired control. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Position Cursor
In the code module behind the form being opened, place this code:
Private Sub Form_Load() Sign_In_Date.SetFocus End Sub BTW, it's a very bad practice to use names that have spaces in them, as it requires a number of different extras things, depending on what you're doing, to handle them.. SignInDate is much better than Sign In Date -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#5
|
|||
|
|||
Position Cursor
Thx Fredg.....As you can probably tell, I'm new and teaching myself. I
appreciate the help. "fredg" wrote: On Fri, 26 Mar 2010 16:19:01 -0700, wrote: When I click on Add a form from the switchboard, how do I tell it where to place the cursor. When my form loads, I would like to cursor to be in the fieldname 'Sign In Date' Thx Either .... 1) Set the Tab Order for the [Sign in Date] control to position 0. In Design View, click on View + Tab Order When you open the form that control will have the focus. or... 2) Code the form's Load event: Me![Sign in Date].SetFocus Only the first record will have [Sign in Date] the focus: or 3) Code the Form's Current event: Me![Sign in Date].SetFocus Each time you go to the next record, that control will have the focus. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail . |
Thread Tools | |
Display Modes | |
|
|