MS Access table field validation rule for only 5 letters and 5 numbers?

Question

What format can be used as field validation rule that user must enter 5 letters first and then 5 numbers? is it possible without codes??

Answer 1

You should be able to accomplish this with an InputMask:

LLLLL00000

If you do not want to use the InputMask, you could write the validation rule like this:

Like "[0-9][0-9][0-9][0-9][0-9][A-Z][A-Z][A-Z][A-Z][A-Z]"

References:

• Characters For Input Masks
• Validation Rules