My website is in ASP VBscript, hosted on a Microsoft Server. 
I want to introduce a forum, powered by an Access database. Users
submit their messages in a memo field. They are not familiar with html
so they can’t be requested to enter html tags to render line breaks.
Is there an alternative solution to render the line breaks?

Elfynet,

You need to replace the line breaks with "<BR>" before storing the
memo value in your database.

Replace(RS(Memofield1), Chr(13), "<BR>")

Chr(13) is the ASCII value for a carriage return. Use the Replace
function to replace it with the HTML code for a line break (<BR>).
When you display the altered value on your web page, everywhere the
user pressed the Enter key will be replaced with <BR>, and the browser
should display it properly.


Google Search Strategy:
ASP access HTML "line breaks" memo


Good luck with your ASP project!

- Hammer

---

Request for Answer Clarification by elfynet-ga on 19 Jun 2003 07:10 PDT

Users post their question directly on our website. 
The forum is not moderated so their contribution is reflected direclty
on the page. I can't process it with a find and replace manually
before it appears. As well users do not know html so they cannot be
requested to use the <br> tag. What I wonder is if I can automatically
render the line breaks without having to modify the source file.

---

Clarification of Answer by hammer-ga on 19 Jun 2003 07:18 PDT

You don't do it manually. You are running some code to collect the
information from the form and put it in the Access database and/or
display it when the user hits the Post button. Add the Replace call to
whatever chunk of code you are using to do this. Take a look at this
example on ExpertsExchange:

ExpertsExchange
Title: Textarea get correct CR
http://www.experts-exchange.com/Developer/Web/Web_Languages/ASP/Q_20008373.html


- Hammer