I am using a scanner to import the numbers associated with bar codes. The numbers are always the same length at 20 characters. When the bar codes are scanned this has to be followed by hitting the enter key to move to the next row. Scan, enter, scan, enter......
This becomes repetitive and missing the "enter" key will result in 2 entries on one line. On average 20,000 of these are scanned in a day.

What I would like to do is this:
I would like to just scan the item and have the highlight move to the next row thus eliminating the need to hit the enter key. Can this be done? I have tried simple macros to no effect and have struck out trying to limit the amount of data the field will accept.

Any thoughts, suggestions or help would be greatly appreciated.