Another Quotation Question

[andy570]

This one has me confused. I have tried using both a SQL statement and a cfinsert statement. Here is the problem...when I type the message in the text area I can use quotation marks and they work fine....however, when I copy from another source (Word, or IE) and paste into the textarea I receive boxes where the quotation marks should be and to fix I must update them by typing in the quotation marks.

Is there a way to have MSAccess return the boxes as quotations when entered via copy and paste?

Thanks in advanced!

 

[TruthInSatire]

Weird problem.
I wonder where that is happening, the CF side or the DB side. Try using CF and replace(""",""", "all&quot on the way into the database. That would replace the questionable "'s with "'s you know are right.
Let me know.

http://thereptilian.com/