Limit input to alphanumeric only

[ireckonso]

I tried searching for this, but couldn't find anything. It's probably not difficult, I just can't see it. Anyway, I want to limit the input for a field to alphanumeric (letters and numbers) characters only. No spaces, punctuation, slashes, dashes, etc. Any help would be greatly appreciated.

[-Queue-]

Well, you can either use a long field validation calculation of:

PatternCount(field, "A") + PatternCount(field, "B") + PatternCount(field, "C") + PatternCount(field, "D") + PatternCount(field, "E") + PatternCount(field, "F") + PatternCount(field, "G") + PatternCount(field, "H") + PatternCount(field, "I") + PatternCount(field, "J") + PatternCount(field, "K") + PatternCount(field, "L") + PatternCount(field, "M") + PatternCount(field, "N") + PatternCount(field, "O") + PatternCount(field, "P") + PatternCount(field, "Q") + PatternCount(field, "R") + PatternCount(field, "S") + PatternCount(field, "T") + PatternCount(field, "U") + PatternCount(field, "V") + PatternCount(field, "W") + PatternCount(field, "X") + PatternCount(field, "Y") + PatternCount(field, "Z") + PatternCount(field, "0") + PatternCount(field, "1") + PatternCount(field, "2") + PatternCount(field, "3") + PatternCount(field, "4") + PatternCount(field, "5") + PatternCount(field, "6") + PatternCount(field, "7") + PatternCount(field, "8") + PatternCount(field, "9") = Length(field)

or you can use a repeating field calc as in the attachment.

an_validation.zip

[EddyB]

Hi queue,

They're both brilliant examples, I wanted to do this a while ago but could not figure it out so gave up in the end.

This is definitely one I'll keep for future use.

Thanks for sharing

Ed.

[ireckonso]

Queue,

Thank you so much, both of these methods produce the results I was looking for.

[-Queue-]

I reckon it's no problem, Ireckonso...