Auto Tab when the value of a text is scanned into textbox and/or entered manually

[Pookiemeister]

USERFORM TEXTBOXES
EmpBadgeID
(Tab Index=0)
(Auto Tab = Yes)
(Enabled = Yes)
(Locked = No)

EmpFulName
(Tab Index=1)
(Auto Tab = Yes)
(Enabled = No)
(Locked = Yes)

Item
(Tab Index=2)
(Auto Tab = Yes)
(Enabled = Yes)
(Locked = No)

On my userform, I have three textboxes, how would I auto tab from EmpBadgeID to Item. Basically skip over EmpFullName. The problem that arises is when a badgeID is scanned instead of manually entered. When manually entered, what I am wanting to do, works but not when they scan they their badge ID. The total number of digits entered has to be eight. No more, no less. So I need to look at EmpBadgeID length and if it equals eight then tab to Item? Is this possible? I had even changed the Tab Index so that Item is set to 1 and EmpFullName is set to 2. Here is what I have so far and it does not work. Thank you.

Private Sub EmpBadgeID_AfterUpdate()
   If Len(Me.EmpBadgeID.Value) = 8 Then Me.Item.SetFocus
End Sub

 

[James006]

Hi,
You should test the TextBox1_KeyPress event instead of Change or AfterUpdate.

 

[Pookiemeister]

Will that work when a user scans their badge rather than entering it in, because there are no keystrokes when they scan their badge number. Thanks for the quick reply.

 

[James006]

At least ... it is worth a try ... since keypress works with ASCII and scan does simulate keyboard inputs ...

Do not know the result since have not tested it myself ... Do not hesitate to share your feedback ...

 

[Micron]

I think the solution often given is to set the Enter key property (File>Options>Client Settings) to go to the next field. Not sure, have never used a scan gun. Or take the control right out of the tab order: Property Sheet> Other tab > Tab Stop > No

 

[welshgasman]

Will that work when a user scans their badge rather than entering it in, because there are no keystrokes when they scan their badge number. Thanks for the quick reply.

I believe the scanner can be set up with a termination character. You choose what it is?