- In the Table make the length of the underlying Field to 1
- In the Form set it's Input Mask to L
- In Properties - Other set the AutoTab Property to Yes
Or, where X is the maximum length of the data in YourTextBoxName and NameOfNextControl is the next control to gain focus.
Code:
Private Sub YourTextBoxName_Change()
If Len(Me.YourTextBoxName.Text) = X Then
NameOfNextControl.SetFocus
End If
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007