Validation rules

[Diksha1310]

Hi! Can someone tell me what is the validation rule for entering data in a particular format? For e.g, BookID must be in the format AAA999(for e.g,Hau344) ...values out of this format are not accepted(e.g,H4s09)!!
Please help..

 

[Steve C]

Hi Diksah

BookID sounds like a Primary Key field – if it is, I suggest Access should decide what to choose – you will never care what the actual number is – nor will you ever change it!

Perhaps you might have another field MyBookID for your own code for a book.

You might use an Input Mask

>LLL000

3 letters and 3 numbers are required to be entered, also, lower case letters will be converted to Upper case.

I am new around here – and this is my first answer ever on the Forum. Hopefully somebody will jump in and tell me if that’s duff info.

Best Wishes

Steve C