I have created a module with a function that capitalizes the third letter in words that begin with ‘Mc’. I have a table with the city field all uppercase letters. I created an update query that takes the field and correctly changes it. I was wondering how you would go about tying this function to the textbox on the input form. So, if a user incorrectly enters ‘mccoy’ in the City Field the function would be called and would automatically change it to ‘McCoy’.
Thanks in advance for any help,
KSmith