Need really rapid input form

[rpadams]

I have been asked to summarize the results of a survey that has already been conducted.
Each participant was asked to respond to 200 questions with a multichoice answer null or 1 to 5. My table has 200 fields A1 to A200. I need to populate these fields with the answers but there are over 4000 participants! I need a really fast way to type in the responses. I would prefer NOT to have to use any keys except the number pad and not separate the entries using the enter or tab key -- just input a straight string of numbers for each participant. Can this be done, maybe by parsing a string at the end of each participant? If yes, please tell me how.

 

[cogent1]

I seem to remember doing this by using the Auto-tab feature in the field's property. The cursor automatically jumps to the next field after the entry, obviating the need for parsing.
Set the field length to one character. When the character has been entered, the cursor leaps, like a young gazelle to the next field...

 

[rpadams]

Excellent. Just what I was looking for. The only thing else I had to do was set a 1 character input mask or you still need the enter key.

 

[OPMCoordinator]

Brilliant!

I always wondered what that autotab bit was for - now i know!

this technique works when scanning in barcodes as well - just set input mask for the size of the barcode and voila - trigger happy data entry!

Mike C