Jump from one textbox to another

[Anna]

Is it possible when user enters date in date1 textbox cursor
automatically jump to date2 text box. My settings are as follows:

input mask 00/00/00
format property mm/dd/yy

Thank You.

 

[Toine]

you can perhaps determine the length of the string inputted in date1.
and set the focus to the dat2 field as soon as all numbers are filled
in at the dat1 field

(in afterupdate_dat1 sub)
if len(me.dat1.value)=6 then
me.dat2.setfocus
endif

 

[Svetlana]

On after update event of your first textbox set the focus to the other
textbox as
Me.NameOfTextBox2.SetFocus

 

[Anna]

when i run the script in debug mode Len(Me.Date1.Value), it shows null.

If Len(Me.Date1.Value) = 6 Then
Me.Date2.SetFocus
End If

---------------------------------------------------

 

[Ken Snell \(MVP\)]

If you want to try Toine's suggestion, use Text property:

If Len(Me.Date1.Text) = 6 Then
Me.Date2.SetFocus
End If

 

[John Nurick]

If a textbox has an input mask, you can just set its Autotab property to
make the focus jump to the next control in tab order when the user has
typed enough characters to "fill" the input mask.