Rereplace Apostrophes?

[CFusionNewb]

First off let me preface this with I'm new to programming in general.

I'm working with coldfusion 10 and an access database

The problem I am having is regarding a certain form, people that use this web app like to copy and paste into the form fields and sometimes when they paste apostrophes they insert into the database as |-

Now its not really a problem until they attempt to open up the form they submitted and it pulls these fields with the strange character, thats when it takes a crap.

For the time being i just replace the strange characters with apostrophes in the database and everything is good to go.

I have been reading up on rereplace and I'm wondering if that would be the best solution

Any help would be greatly appreciated

[p_sim]

Check PreserveSingleQuotes() and HTMLEditFormat().