Problem with text stored in database

[gardijan]

I have problem with text written in textarea like this and then stored into database. When I store text like this:

This is text I'm inserting into
database.
I'm using "new lines(enter)" which I can't display on my web page.


On my web page It looks like this:

This is text I'm inserting into database. I'm using "new lines(enter)" which I can't display on my web page.

What can I do to awoid this?

[parksie]

Either:

a) When storing the text in the database, replace all newlines with "<br>"

b) On the page, enclose the text in <pre></pre> tags.

[gardijan]

How can I replace newline with "<br>" if I'm inserting text into textarea box and then inserting into database?

sHTMLText = Replace(sPlainText, vbcrlf, "<br>" & vbcrlf)

[gardijan]

Thanks. It works with <pre> </pre>