Text Box event Coding - Jump to next field after using barcode scanner

[Hauler2me]

I am creating a inventory database for work. I am trying to get the cursor to jump to the next text box for data entry using a barcode scanner. I have a limit on how many characters there can be in this field but yet even after it is all filled the cursor stays in that same field. I am fairly new to access, especially in code building.
Do I use "After Update" under "Event" in the "Property Sheet"?

 

[Minty]

I think this is a bar code scanner issue - you want the scanner to send an "Enter" / Carriage return after it has performed a scan.
You'll need to adjust the scanner settings. Your tab order should then be sufficient to get you to the correct next field.

 

[CJ_London]

if you can't get the scanner to send an enter/carriage return, your only other option is to use the change event - afterdate and beforeupdate won't be triggered.

the problem with using the change event is if the user decides to type in a code manually, then a change event triggered every time he/she enters a character.

you would be better to fully investigate Minty's suggestion first

 

[JLCantara]

Hello Minty & Hauler2me!

I doubt it will work: enter CR/LF using the Alt technique and you will notice that they are accepted as 'normal' character not as one would expect.

One solution is to have duplicate fields:
1 - one for barcode entry with the Change event (flat, possibly light grey background color)
2 - one for manual entry without Change event (3D with white background)

A button could be used to select the proper entry mode fields - with, say, #1 as default. Both fields being superimposed, this button sets the Visible property to present the selected entry mode...

Good luck, JLCantara.

 

[Uncle Gizmo]

I also agree with Minty.... In addition, barcode scanners normally jump to the next control in the tab order by default. (Straight out of the box)

So I would guess that the barcode scanner settings have been changed by someone.

On the barcode scanners I have seen these settings are changed by barcodes listed in the manual that comes with the barcode scanner.