General discussion

Locked

access - validation rule

By ka75 ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by PubServant In reply to access - validation rule

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 "<".

Collapse -

by ka75 In reply to

It works !!!

Many thank's
Itay

Collapse -

by ka75 In reply to access - validation rule

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums