Hi

I have a text area returveing input form the user.

Although the user can press return to create a new paragraph and htis show in the text area. When i write it the database and later output it to a web page, the carriage return is not there.

Could someone please tell me how i write the carriage returns from a text area to a database field with the input text.

cheers

If you look at the source code, the carrage returns will be there. They just don't render in HTML because they're considered whitespace. What you need to do is replace them with a <br /> tag.

Response.Write(Replace(MyDBValuue, Chr(13), "<br />"))

THANKS

Although chr(13) will work in most cases, I find vbCrLf works more often (Visual Basic Carriage Return/Line Feed). I'll also use it when outputting HTML to put a line break in where I want it.

e.g.

Response.Write "<div>Some Code</div>" & vbCrLf

It's a wonderful thing, that vbCrLf is.

The other thing you may wish to implement is something to ensure that double carriage returns are paragraphed.

e.g.

Text_Input = Request.Form ("yourtextarea")
if Text_Input <> "" then ' Replace won't work on null entries.
Text_Input = Replace (Text_Area, vbCrLf & vbCrLf, "</p><p>")
Text_Input = Replace (Text_Input, vbCrLf, "<br />")
Text_Input 
end if

Although chr(13) will work in most cases, I find vbCrLf works more often (Visual Basic Carriage Return/Line Feed). I'll also use it when outputting HTML to put a line break in where I want it.

e.g.

Response.Write "<div>Some Code</div>" & vbCrLf

It's a wonderful thing, that vbCrLf is.

The other thing you may wish to implement is something to ensure that double carriage returns are paragraphed.

e.g.

Text_Input = Request.Form ("yourtextarea")
if Text_Input <> "" then ' Replace won't work on null entries.
Text_Input = Replace (Text_Area, vbCrLf & vbCrLf, "</p><p>")
Text_Input = Replace (Text_Input, vbCrLf, "<br />")
Text_Input = "<p>" 
end if

Although chr(13) will work in most cases, I find vbCrLf works more often (Visual Basic Carriage Return/Line Feed). I'll also use it when outputting HTML to put a line break in where I want it.

e.g.

Response.Write "<div>Some Code</div>" & vbCrLf

It's a wonderful thing, that vbCrLf is.

The other thing you may wish to implement is something to ensure that double carriage returns are paragraphed.

e.g.

Text_Input = Request.Form ("yourtextarea")
if Text_Input <> "" then ' Replace won't work on null entries.
Text_Input = Replace (Text_Area, vbCrLf & vbCrLf, "</p><p>")
Text_Input = Replace (Text_Input, vbCrLf, "<br />")
Text_Input = "<p>" & Text_Input & "</p>" ' This is done in case you have multiple paragraphs.  If not, it's still safe coding.
end if

Play with that. It should get you where you want to go.

Weird. It submitted 3 times.

Any mods out there that can fix that? I didn't do that, I swear.