How do I set up a form to automatically move to next field

  • Thread starter Thread starter vic inglis
  • Start date Start date
V

vic inglis

I'm stumped. I'm keying information in to create a new
database via a Form. Some fields have set length. How do
I get the cursor to automatically move to the next field
at the end of keying one field. At the moment I'm having
to hit the enter button to move to next field. In old
Dbase it was the 'set carry to' query but doesn't appear
to register in access.
Any help appreciated!
 
Presumably you want to move after entering a fixed number of characters.

An input mask might do that. Alternatively, use the Change event to examine
the text box's Text property, and SetFocus to the next one. This kind of
thing:

Private Sub MyTextbox_Change()
If Len(Me.MyTextBox.Text) >= 6 Then
Me.MyNextBox.SetFocus
End If
End Sub
 
I'm stumped. I'm keying information in to create a new
database via a Form. Some fields have set length. How do
I get the cursor to automatically move to the next field
at the end of keying one field. At the moment I'm having
to hit the enter button to move to next field. In old
Dbase it was the 'set carry to' query but doesn't appear
to register in access.
Any help appreciated!
Click to expand...

Be sure that the length of the field in the table matches the desired
length, and set the form text box's Auto Tab property to True.
 
Back
Top