People's Names with Special Characters

Banana

split with a cherry atop.
Local time
Yesterday, 22:13
Joined
Sep 1, 2005
Messages
6,318
My search has been unsuccessful due to the search function refusing to play nicely with me and the fact that it's mixing up the problems with using special characters with field names, which isn't what I want.

My problem is I have comboboxes that looks up people's name and has a NotInLIst event to allow addition of new person. It uses split function and concentating query to keep data normalized while displaying the full name.

Access trips over, very hard, whenever there is a name that uses special character, which for obvious reasons, causes confusion. Example:

Mike O'Leary
Thomas O'Calloway
Janet Smith-Johnson
Mary-Ann Johnson

Can anyone point me to a snippet I could use to trap for those names and help Access deal with it accordingly?

Thanks in advance.
 
Perfect! This is what I needed!

Thanks for the pointer! :)
 

Users who are viewing this thread

Back
Top Bottom