Solved Validation rule at least 6 characters (1 Viewer)

Kayleigh

Member
Local time
Today, 12:21
Joined
Sep 24, 2020
Messages
706
Please can someone help with the syntax to write a validation rule for a text field to allow no less than 6 characters of alphanumeric characters.

Thanks
 

CJ_London

Super Moderator
Staff member
Local time
Today, 12:21
Joined
Feb 19, 2013
Messages
16,619
that doesn't check for non alphanumeric characters - suggest

Len([YourTextColumn]) >= 6 and not [YourTextColumn] Like "*[!0-9a-zA-Z]*"
 

Cotswold

Active member
Local time
Today, 12:21
Joined
Dec 31, 2020
Messages
528
I would also Trim([YourTextColumn]) either before CJ_London's code is run. Anything like this I use Trim() as a matter of course.
 

Users who are viewing this thread

Top Bottom