I have a field asking for a county name. There are 77 possible counties to
enter. I want to ensure that the user enters a valid county and has it spelt
correctly. Is there a way to do this? Can I have the validation point to text
file with all the acceptable entries? Also is there a way to format the cell
to convert anything entered into all upper case?