Password Validation?

[sleepinggypsy]

Does anyone have a validation formula or custom function that validates that a text password field is 6 digits minimum and contains only letters and numbers. Thanks in advance.

[Genx]

Case(Length(text) > 6 ; "Valid" ; "Invalid" )

As for the alphanumeric thing, you could do a substitute of all 26 characters and 9 numbers and if the result is an empty string, it's valid, otherwise its invalid.

i.e.

If(Length(text) > 5 and

IsEmpty(

Substitute(text ;

[ "a" ; "" ] ;

[ "b" ; "" ] ;

[ "c" ; "" ] ;

.......

[ "9" ; "" ] ;

[ "0" ; "" ])

)

; "Valid" ; "InValid" )

~Genx

[Genx]

P.s. im not sure if subsitute function is case sensitive, but if it is, you'll be doing that for 52 letters

~Genx