Validation rules - digits & letters only

C

Carol Shu

Hi, I have a table name [tblVehicle], and a field name [SerialNumber], i set
the validation rule to this field : IS NULL OR NOT LIKE "*[!((A-Z) OR
(0-9))]*", it will accept digits and letters only.
How do you add another validation rule to this, like the letters "I", "O"
and "Q" never appear in a VIN (SerialNumber), thanks.
 
K

KARL DEWEY

UNTESTED ---
IS NULL OR NOT LIKE "*[!((A-H) OR (J-N) OR (P) OR (R-Z) OR (0-9))]*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com) 0
Validation Rule 2
Validation arguments 3
Input Mask or Validation? 24
Validation Rules for a Control on a Form (?) 4
Validation Rules ? 5
Validation rule for alpha, -, ' 10

Top