Solved Validation rule at least 6 characters

Kayleigh

Member
Local time
Today, 23:31
Joined
Sep 24, 2020
Messages
709
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
 
that doesn't check for non alphanumeric characters - suggest

Len([YourTextColumn]) >= 6 and not [YourTextColumn] Like "*[!0-9a-zA-Z]*"
 
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

Back
Top Bottom