Software

Ask something
Discussion Locked

access - validation rule

0 helpful
3 replies

by ka75

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to create a rule, that will accept into a field in a table, only text built of 3 letters followed by 3 numbers, for example:
'abc123'.

the next rule will do some of the work by checking for 3 numbers.
Like "###"

What do I write to make the rule check for 3 letters and 3 numbers ?

Itay K

3 replies

by pubservant

You can do what you want to do with an Input Mask. The input mask LLL000 will limit the field entries to three letters followed by three digits. The uppercase L indicates that entering three letters is mandatory, and the 0's - numeric zeroes - indicates that entering three digits is mandatory.

Use the mask ???999 if entry in the field is optional. You can also force the entry to uppercase by using the greater than sign, ">", before the mask, or force it to lowercase by using "<".

This discussion is closed to new replies.