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.

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

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.

Queue,

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

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