Auto Tabbing upon entry

[Guest]

I have a form that has several fields, but 4 of the fields require only a 2
digit character before moving to the next field. Is there away to
automatically move to the next field upon entering the two digits required.
Bascially move without having to hit the tab key between entries.

Thanks in advance.

 

[Rick Brandt]

I have a form that has several fields, but 4 of the fields require
only a 2 digit character before moving to the next field. Is there
away to automatically move to the next field upon entering the two
digits required. Bascially move without having to hit the tab key
between entries.

Thanks in advance.

I "think" AutoTab only works with a numeric field if you have an InputMask
on it. Otherwise Access has no way of knowing you have hit the maximum
number of characters.

 

[Alex White MCDBA MCSE]

You could monitor the key up event for the textbox

Private Sub myDate_KeyUp(KeyCode As Integer, Shift As Integer)
If Len(Trim(myDate.Text)) > 1 Then
Me.Text1.SetFocus ' goto the control you want
End If

End Sub

 

[Guest]

The Auto Tab property works for any characters entered, but does require an
InputMask with the correct length defined.

 

[Rick Brandt]

The Auto Tab property works for any characters entered, but does
require an InputMask with the correct length defined.

Yes, but how do you define the "correct length" if the field the control is
bound to is not text?

 

[Guest]

See the InputMask property info in Access Help.

For two digits required 00
For two digits not required 99

 

[Rick Brandt]

See the InputMask property info in Access Help.

For two digits required 00
For two digits not required 99

I believe that is what I originally stated; that if the field was numeric
the OP would have to add an InputMask to make AutoTab work and you responded
by saying an InputMask was not required.

 

[Guest]

Reread my post, Rick, I said an input mask with the proper length is required.

 

[Rick Brandt]

Reread my post, Rick, I said an input mask with the proper length is
required.

My mistake. I looked at "does" and saw "doesn't".

 

[Guest]

I have never misread a post and given incorrect advice

No problem, Rick