Auto Tab

[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

 

[Jeff Boyce]

It sounds like you've already tried setting the property that would do this.

So, what actually HAPPENS when you try it ("didn't work" doesn't really give
us much to go on)?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

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]

 

[KimTong via AccessMonster.com]

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

 

[John W. Vinson]

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]

 

[KimTong via AccessMonster.com]

Hi John,

It works. Thank you very much...

Hi John,

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