ASP FORM, Text Formatting.

[fishbone34]

Hello, I have a ASP form that has a text box. I type something in it and create Formatting and submit the results to my MSSQL database.

When I pull the results using a ASP form, The Text box looses its formatting.

Example:

Text Box Entry:
- TEST TEXT
- TEST TEXT
- TEXT TEXT

When I view it using a ASP form, It populates the text box like this:
- TEST TEXT - TEST TEXT - TEXT TEXT

QUESTION: How can I tell the Form/Database to retain the formatting using ASP?

Thank you to anybody who can help.
Chris@thesouthside.net

Chris

[glenngv]

Put the content inside <pre> </pre> tags

<pre>
<%=rs("theField")%>
</pre>

[fishbone34]

It works!

Thanks!

Chris

[Bullschmidt]

And at least for Access databases this can work:

' Convert all vbCrLf to <br>.
' (This is the same as converting Chr(13) & Chr(10) to <br>.)
theFld = Replace(theFld, vbCrLf, "<br>")