Field validation to prevent ampersands

[brainonastick]

Hi there,

I want to prevent users entering ampersands (&) into a field. Can I use validate by calculation and if so how do I code up the calculation?

[Vaughan]

You cannot stop people from *entering* things into a field, but you can stop them from *committing the record* until the offending characters are removed.

Validation by calculation:

Patterncount( field ; "@" ) = 0

[mr_vodka]

Try

not PatternCount ( yourField; "&" ) as the validation calc.