Textarea - Handeling the Line Break

I can convert characters to chr(?) but what about line breaks

[chris_f]

Hi Guys,

I use line's like

MsgContent = Replace(MsgContent, "'", "' & Chr(39) & '")

to stop ' from breaking my database insert queries. I am looking to do the same for the return key. At the minute, if someone presses return in my textarea it is converted into nothing. I am looking to convert it into either vbcrlf or <br>. How would I represent the line break in the above code?

Chris

[chris_f]

No worry.

Fixed using

MsgContent = Replace(MsgContent, Chr(13), "<br>")

Chris.

[joshie76]

or

Replace(MsgContent, vbcrlf, "<br>")