August 14, 200421 yr 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!
August 15, 200421 yr 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)).
Create an account or sign in to comment