Jump from one textbox to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anna - 30 Aug 2006 13:42 GMT

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.

Reply to this Message

Toine - 30 Aug 2006 14:01 GMT

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

>Is it possible when user enters date in date1 textbox cursor
>automatically jump to date2 text box. My settings are as follows:
[quoted text clipped - 3 lines]
>
>Thank You.

Reply to this Message

Anna - 30 Aug 2006 14:21 GMT

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

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

> 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
[quoted text clipped - 12 lines]
> >
> >Thank You.

Reply to this Message

Ken Snell (MVP) - 30 Aug 2006 16:50 GMT

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

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

Signature

Ken Snell
<MS ACCESS MVP>

> when i run the script in debug mode Len(Me.Date1.Value), it shows null.
>
[quoted text clipped - 19 lines]
>> >
>> >Thank You.

Reply to this Message

Svetlana - 30 Aug 2006 14:02 GMT

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

Reply to this Message

John Nurick - 31 Aug 2006 08:16 GMT

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.

>Is it possible when user enters date in date1 textbox cursor
>automatically jump to date2 text box. My settings are as follows:
[quoted text clipped - 3 lines]
>
>Thank You.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message