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

[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.

 

[Jeff Boyce]

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

 

[fredg]

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.

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

 

[John W. Vinson]

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.

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.