Validating Proper Text Case

[Dagel]

I need to throw up an error message when a user attempts to enter all lowercase or all uppercase text in a field. I've been correcting the entries after importing their data using the Proper function, but that's not appropriate for use across the board.

Thanks for any suggestions!

[-Queue-]

Try creating a validation of Exact( text, Proper(text) ).

[RalphL]

Proper may not always work. Names like McGee and O'Brien don't work with proper. Maybe try Not Exact (Text, Upper (Text)) and Not Exact (Text, Lower (Text)).

[Dagel]

You guys are awesome! That did the trick!