Kayleigh Member Local time Today, 23:31 Joined Sep 24, 2020 Messages 709 May 11, 2023 #1 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
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
S sonic8 AWF VIP Local time Tomorrow, 00:31 Joined Oct 27, 2015 Messages 1,248 May 11, 2023 #2 Len([YourTextColumn]) >= 6
C CJ_London Super Moderator Staff member Local time Today, 23:31 Joined Feb 19, 2013 Messages 17,472 May 11, 2023 #3 that doesn't check for non alphanumeric characters - suggest Len([YourTextColumn]) >= 6 and not [YourTextColumn] Like "*[!0-9a-zA-Z]*"
that doesn't check for non alphanumeric characters - suggest Len([YourTextColumn]) >= 6 and not [YourTextColumn] Like "*[!0-9a-zA-Z]*"
Cotswold Well-known member Local time Today, 23:31 Joined Dec 31, 2020 Messages 925 May 11, 2023 #4 I would also Trim([YourTextColumn]) either before CJ_London's code is run. Anything like this I use Trim() as a matter of course.
I would also Trim([YourTextColumn]) either before CJ_London's code is run. Anything like this I use Trim() as a matter of course.