Function stopped working (MSACCESS 2003)

I have a form that has a textfield used as a memo. The text entered can contain any words, however on its exit it checks to see if any words typed in are Keywords. It runs a function that checks the keywords in a table, and if found amends the textbox to uppercase on the found keyword. This was all working okay, but now it has stopped working. Would appreciate any help, I thought this was dead and buried. Regards

Re: Function stopped working (MSACCESS 2003)

It works OK for me. Keep in mind that keywords will only be changed to upper case if there is a space before and after them.
Does the problem persist after closing and reopening the database? After restarting your PC?

PS I'd use the After Update event of the Comments text box instead of the On Exit event.

Re: Function stopped working (MSACCESS 2003)

Thanks Hans. I put it on a CD and ran it on my main PC, again does not work?
It goes off into the function, but Txt ends up being thesame as typed in ie lower case. Just when I did'nt need this. Thought it might have been Access on my laptop not working but doing it on my standalone pc makes it a problem.. Oh well thanks for your help, problems in my court. Regards

Re: Function stopped working (MSACCESS 2003)

Hans, I just took a sedative and read slowly what you had said - needs a space before and after. I was adding a word at the end of my text and that was the reason for failure. It works thanks to your help, however I now need to see how if a word was added like I did at the end then how to overcome it being bypassed. Regards