I want to automatically move to the next cell without tab, etc

  • Thread starter Thread starter kendraarianna
  • Start date Start date
K

kendraarianna

Is there a way to automatically move to the next field once a set number of
characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
characters. Once I keyed the 5 characters I want to automatically advance to
the next field.
 
One of the possible "unintended consequences" of doing this might be that a
user would type 8 characters, the first five of which would show up in that
control, and the final 3 would show up in the NEXT control!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Is there a way to automatically move to the next field once a set number of
characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
characters. Once I keyed the 5 characters I want to automatically advance to
the next field.
Click to expand...

Let's assume the name of this control is "LastName" and the 'next
field' on your form is named "FirstName".

Code the [LastName] control's Change event:

If Len(Me.[LastName].Text) >= 5 then
Me.[Firstname].SetFocus
End If
 
Is there a way to automatically move to the next field once a set number of
characters has been keyed. Ex. I set a field in access 2003 to a limit of 5
characters. Once I keyed the 5 characters I want to automatically advance to
the next field.
Click to expand...

If the field will ALWAYS contain five characters, no more no fewer, you can
set the textbox's Auto Tab property to Yes.

This assumes you're using a Form. Do so. Table datasheets are VERY inflexible
and limited, and not suitable for use for data entry any professional
application.
 
Back
Top