Hmmmmmmmmmm... it depends on your use of it. If it is purely for web input and display, Mr. Wakefield's answer is a good one. Beyond that, I confess I am not expert enough with Access to be able to offer a viable solution. Perhaps if you wer able to surround the form value with double-quotes on the INSERT/UPDATE statement, that would work.
john -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kristi J. Bohling Sent: Wednesday, February 25, 2004 12:13 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] single quotes in text answers Access 2000 ----- Original Message ----- From: "John Mack" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 25, 2004 12:10 PM Subject: RE: [KCFusion] single quotes in text answers > What database are you using? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Kristi J. Bohling > Sent: Wednesday, February 25, 2004 12:07 PM > To: [EMAIL PROTECTED] > Subject: [KCFusion] single quotes in text answers > > > We have a text entry area where users can enter a short answer. They are > including single quotes in their answer. This is causing an issue when > trying to submit this data to the database... it is hitting the single > quote, and is acting as if this is the end of the text string to be entered. > Anyone have a quick fix or a function that I missed? Kristi > > > > ========================================================= > Kansas City ColdFusion User Group's website & listserv is > hosted through the generous support of Clickdoug.com > To send email to the list, email [EMAIL PROTECTED] > To (un)subscribe, email [EMAIL PROTECTED] with your request. > For hosting solutions http://www.clickdoug.com > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. > ====================================================== > > > ========================================================= > Kansas City ColdFusion User Group's website & listserv is > hosted through the generous support of Clickdoug.com > To send email to the list, email [EMAIL PROTECTED] > To (un)subscribe, email [EMAIL PROTECTED] with your request. > For hosting solutions http://www.clickdoug.com > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. > ====================================================== > > ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ====================================================== ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
