Auto Tab

  • Thread starter Thread starter KimTong via AccessMonster.com
  • Start date Start date
K

KimTong via AccessMonster.com

Hi,

Is anyone know how to make auto tab without pressing tab/enter key?. So when
the user enter the first field has 8 digits, it's automatically goes to the
next field. I did try to change the auto tab property to 'Yes', but it didn't
work. Any other suggestions?

Thank you in advance.

KFT
 
Hi,

Is anyone know how to make auto tab without pressing tab/enter key?. So when
the user enter the first field has 8 digits, it's automatically goes to the
next field. I did try to change the auto tab property to 'Yes', but it didn't
work. Any other suggestions?
The field must be Text, and must be defined to be 8 characters long for Auto
Tab to work.

John W. Vinson [MVP]
 
Hi John,

You are right, I have 8 characters (in Text) and the user have to enter 8
digits in full. But I still have to press tab/enter key to go to the next
field.

I did try 'on change' property to write Vb script like this:
Me.Nextfield.SetFocus

It works, but the program allow me to enter 1 digit only, and then go to the
next field. Any other suggestions?

KFT
 
Hi John,

You are right, I have 8 characters (in Text) and the user have to enter 8
digits in full. But I still have to press tab/enter key to go to the next
field.

I did try 'on change' property to write Vb script like this:
Me.Nextfield.SetFocus

It works, but the program allow me to enter 1 digit only, and then go to the
next field. Any other suggestions?

Change is the wrong event - it fires on every keystroke.

Try putting an Input Mask

AAAAAAAA

to require entry of eight letters or numbers; remove the Change event; and
just be sure that the Auto Tab property is Yes.

John W. Vinson [MVP]
 
Hi John,

It works. Thank you very much...
[quoted text clipped - 7 lines]
It works, but the program allow me to enter 1 digit only, and then go to the
next field. Any other suggestions?

Change is the wrong event - it fires on every keystroke.

Try putting an Input Mask

AAAAAAAA

to require entry of eight letters or numbers; remove the Change event; and
just be sure that the Auto Tab property is Yes.

John W. Vinson [MVP]
 
Back
Top