Field Data and Paragraphs

[beruken]

I am querying an Access DB that has some of the text/memo fields data in Paragraph form. Question is, why do I loose my formatting when returning data to my web page?

i.e inserted into db as....

Sentence One

Sentence two

Returned from db as...

Sentence One Sentence Two

 

[derren]

Hi

Within a memo field a carriage return is a valid character, but in HTML it means squat.

Just do this

response.write(replace(rs(&quot;yourfield&quot;),vbCrlf,&quot;<br>&quot; ))

and your formatting will be preserved. Derren
[Mediocre talent - spread really thin]