I was wondering if there is a way I can set a form to auto advance the cursor to the second field once the appropriate number of digits has been entered in the first field.
I have a process where an operator enters a series of 26 single digits reading from a vendor product sheet. The data that is sent from the form however is needing to be in different fields. Field 1 has 3 of the 26 digits, field 2 has 6 of the 26, and so on. Normally they just "ten key" the 26 digits and move to the next entry. Excel allows you to limit the field length, and it moves to the next cell automatically once the previous is filled. It also works with a bar code scanner and all the digits get entered in the correct cells.