Delete Special characters

[fuzzygeek]

Response to earlier posting

Didn't see the question until today. dcx693 was correct, Manu,
UPDATE tblTest SET tblTest.Phone = fncEditPhoneNumbers([Phone]) WHERE (("1"="1")); the WHERE clause is not needed. Sorry reversion to something I had to do in Access 2.0 about 8 years ago.

I like raskew "chopit" function much better. Can use it for multiple items...great idea!

Good luck Manu! The great thing about this forum is the diversity of methods that appear and the number of people willing to share so that even old dogs can learn new tricks. ruff!

 

[fuzzygeek]

I duplicated the problem

The problem is that your module name and your function name are the same(even though one begins with a Capital letter). The code ran fine with no errors until I changed the module name to chopit. Then duplicating what you did on the query, I got the undefined function message. Change the name of your module and it should correct your problem.

 

[manu]

Thanks a million Fuzzygeek....it works like a charm

It was quite dumb of me to not recognize that possibility....

Regards & a big thanks to all experts for promptly helping out...

 

[namliam]

If you were using a naming convention you wouldnt have experienced this problem....

mdl For instance for modules....

try it, you will like it...

Regards