You just need to replace all the returns with HTML tags, ASP uses the 
replace function to achieve this.

mynewcomments=replace(mycomments, vbcrlf, "<P>")

> -----Original Message-----
> From: andy@a... [mailto:andy@a...]
> Sent: 19 February 2001 21:02
> To: andy@a...; html_code_clinic@p...
> Subject: [html_code_clinic] Displaying formatted text
> 
> 
> Hi
> 
> I have a form with a text area into which text is typed. The 
> text may be 
> formatted with tabs & carrage returns. This is being written 
> back to an 
> access database memo field. When I look at the database the 
> text is as it 
> was entered (formatted). My question is how do I get the text 
> to display 
> on a page when I pull memo field from the database including the 
> formatting. At the moment it displays but all the formatting 
> is missing.
> 
> Regards
> 
> Andy Green
>