Line breaks in Access memo fields on a webpage
Asked by: elfynet-ga
List Price: $2.50
19 Jun 2003 01:35 PDT
Expires: 19 Jul 2003 01:35 PDT
Question ID: 219127
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 cant be requested to enter html tags to render line breaks. Is there an alternative solution to render the line breaks?
Re: Line breaks in Access memo fields on a webpage
Answered By: hammer-ga on 19 Jun 2003 04:53 PDT
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
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at firstname.lastname@example.org with the question ID listed above. Thank you.
|Search Google Answers for|