Calling a Function From A Form.

[ksmith]

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

[Bob Fitz]

Something like:
Me.ActiveControl = YourFunction()
in the After Update event of the text box.
What is your function called and what arguments does it accept?

[ksmith]

Thanks Bob for your reply, I'm not at a point where I can work on it now. I will try what you suggested and post back.

Thanks again,
KSmith