Ease of Data Entry in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 500 tests I have to record data for. There are 100 test questions,
each are multiple choice, with A, B C, D, and Blank as the data entry
options. Is there a way to ease my data entry pains, instead of having to
type A could I use my 10-key pad and associate A to 1, B to 2, C to 3, D to 4
and Blank to 5? In my table right now I have 100 records and I have a
dropdown value list with A;B;C;D;Blank to choose from. I am much faster on
the 10-key than having to type A, B and so on. I hope I am explaining this
correctly. Please explain in English if you can help. I am not well versed
at this!
 
Correction: I meant to say I have 100 fields on a form - not 100 records, I
will 500 of those once I get done with all this data entry. So question
still stands, can i type 2 and have it be equal to B???? and so on....
 
You could create a combo box that binds the letters to the field, but
displays the numbers. In that way, inputting the number would pass the
correct letter to the table.
 
Back
Top