NEED TO ENTER NUMBERS AND LETTERS IN SAME BOX IN ACCESS

  • Thread starter Thread starter Rich Kamphaus
  • Start date Start date
R

Rich Kamphaus

I am creating an automotive inspection form and need to enter numbers and
letters in the same box to fill in license plate numbers and also for vehicle
identification numbers (V.I.N. #'s).
Thank You,
Rich Kamphaus
 
On Sun, 26 Oct 2008 19:11:00 -0700, Rich Kamphaus <Rich
I am creating an automotive inspection form and need to enter numbers and
letters in the same box to fill in license plate numbers and also for vehicle
identification numbers (V.I.N. #'s).
Thank You,
Rich Kamphaus
Click to expand...

Just use a Text field. The characters "1" and "8" are perfectly valid text
characters just like "A" and "L".

Only use a Number field if you're going to do calculations with the value -
e.g. a Zip Code or phone number should be Text fields, not Number.
 
Back
Top