NEED TO ENTER NUMBERS AND LETTERS IN SAME BOX IN ACCESS

[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

 

[John W. Vinson]

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

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.