Detect a hard return in a textarea when submitting to a db

<i><b>Originally posted by : kyoung (k_young2000@hotmail.com)</b></i><br />I am trying to detect hard returns within a text area so that I can add <br> tags when it is inserted into the database. When I pull it back out it will keep the formatting that the user <br />has entered. Thanking you, Kenny.<br />

<i><b>Originally posted by : Kenny Young (k_young2000@hotmail.com)</b></i><br />This was my question, however this may help others out:<br />FUNCTION fixSpace (strText)<br />fixSpace = Replace (strText, vbCrLf, "<br>")<br />END FUNCTION<br /><br /><br /><br />------------<br />kyoung at 9/18/2000 12:32:21 PM<br /><br />I am trying to detect hard returns within a text area so that I can add <br> tags when it is inserted into the database. When I pull it back out it will keep the formatting that the user <br />has entered. Thanking you, Kenny.<br />