Pattern Validation for Text

In case you need to control the format of the data being entered to a Text field, use the validation option. It can be activated in the Advanced Options section of the Text column settings.

Validation text.png




This checkbox activates the validation specified in the Pattern field.


Here you should specify the format, that should be applied to text column values.



0 or #

Any digit: 0 to 9


Uppercase latin letter: A, B… to Z


Lowercase latin letter a, b to z

Z or z

Any latin letter


Latin letter or digit


Any character


Suppresses any special meaning of the character that follows, e.g. \* means “star”, not “any character”

any other

Treated literally


If a user input does not match the pattern, the message specified in the Message property is displayed.

Here are couple of samples:

0000 0000 0000 0000 – credit card number (4 groups by 4 digits)

(000) 000-0000 – US phone number

000-00-0000 – SSN

00000 – Five-digit postal code

A0A 0A0 – Canadian postal code

?????-?????-?????-?????-????? – 25 characters product key (5 groups by 5 letters or digits)

Also text input was modified to let it handle format on the fly. When focus leaves input field and the input’s value does not contain invalid characters, we reformat it according to the pattern: remove extra spaces, insert required punctuation, convert lowercase letters to uppercase and vice versa. For example, following Canadian postal code pattern, k1 a0 b1 transforms to K1A 0B1

If simple pattern is not enough you can still use regular expressions. Start pattern with regex: and put expression afterwards, here are some examples:

Example 1

regex: ^d\{3,5}$ means 3 to 5 digits are allowed.

Example 2

regex: 0\d*$ means leading zeros and digits 0 to 9 are allowed.

Next: RecordSet Column and ParentKey() function