Auto Tabbing upon entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Sondra said:
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.
Click to expand...

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.
 
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
 
The Auto Tab property works for any characters entered, but does require an
InputMask with the correct length defined.
 
Klatuu said:
The Auto Tab property works for any characters entered, but does
require an InputMask with the correct length defined.
Click to expand...

Yes, but how do you define the "correct length" if the field the control is
bound to is not text?
 
See the InputMask property info in Access Help.

For two digits required 00
For two digits not required 99
 
Klatuu said:
See the InputMask property info in Access Help.

For two digits required 00
For two digits not required 99
Click to expand...

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.
 
Back
Top