Hello!



This would do the trick:

<%=3DReplace(rsDocuments.Fields("fldDescription"), vbCRLF, "<BR>")%>



Where "rsDocuments.Fields("fldDescription")" is the field from the 

database.



/Martin





-----Ursprungligt meddelande-----

Fr=E5n: Andrew Matheson [mailto:amatheso@y...]

Skickat: den 5 augusti 2001 18:09

Till: ASP Database Setup

=C4mne: [asp_database_setup] Detecting Blank lines in memo field





Hi.



I have just set up a simple guest book.  I have a memo field

where the user can type there comments (access database).  The problem 

is

that if the user wants to type..say..three paragraphs they can,  

However

when the guest book is viewed, it appears as one block of text.



Does anyone know how i can utilize code (asp) to detect blank lines

and put an html <br> in it's place to make it display properely

when the book is viewed???



Thanks,



Andrew