apostrophe in form field gives error

<i><b>Originally posted by : Brett (b_brillinger@yahoo.com)</b></i><br />I have a form that sends the results to an .asp page that in turn enters the data into an Access database. It works fine until someone uses an apostrophe in the text they are entering. When the .asp page tries to enter the data into the database, it gives an error. Is there a fix?<br />

<i><b>Originally posted by : ALJ (alj@leaweb.org)</b></i><br /><br />USe this to replace the single quuote in the output of your form<br /><br />Form_Output = Replace(Request.Form("Form_Field"),"'","''")<br /><br />AL<br /><br /><br />------------<br />Brett at 4/19/2000 1:27:19 PM<br /><br />I have a form that sends the results to an .asp page that in turn enters the data into an Access database. It works fine until someone uses an apostrophe in the text they are entering. When the .asp page tries to enter the data into the database, it gives an error. Is there a fix?<br />