Validation for Barcode Entry. Must contain at least one letter.

[Matt_H]

I have technicians rapidly scanning package Tracking numbers.  On the labels there are up to 5 barcodes and the operators often scan the wrong one.  I've solved most problems with a >14 character length validation.

However, valid entries must have at least one LETTER.  Is there a better way than the following?

OR(CONTAINS([_THIS],"A"),
CONTAINS([_THIS],"B"),
CONTAINS([_THIS],"C"),
CONTAINS([_THIS],"D"),
CONTAINS([_THIS],"E"),
CONTAINS([_THIS],"F"),
CONTAINS([_THIS],"G"),
CONTAINS([_THIS],"H"),
CONTAINS([_THIS],"I"),
CONTAINS([_THIS],"J"),
CONTAINS([_THIS],"K"),
CONTAINS([_THIS],"L")...

)

[SkrOYC · Accepted solution]

Good idea.

So it would be

Number([_THIS])=0

What's the posibility of having a code without a letter and just zeros? If it's low and almost impossible, it should work