Help!

When I do an insert into the DB I do a find and repalce (replace("'","''"))
on single quote marks (ticks) in order to keep the insert working correctly.
I have recently ran into several problems where users are coping and pasting
their remarks into text fields, this is fine however, I have found that if
their font is set to Courier New, ticks turn into acute accents which cause
the insert to fail. My question is how do I check for these? I have tried
replace("´","''") and replace("´","''") with no success. Does
anyone know how to correct this?

Thanks in advance for any help!

MDB