Display Text Entered In Text Areas Entered With Carriage Return 1

[Skittle]

I have a text area that accepts multiple lines of free format text. A user can of course hit 'enter' or 'carriage return' when filling in the text area to end a line and start typing on the next line.

My user entered text area is stored in an Access database
'Text' field type. If I read the field in on another page via a standard ASp SQL connection, the text is displayed without the 'enter'/'carriage return' ekystrokes formatting the data. They seem to be treated as space characters only.
Why is this and how can I display the text area values in the format the user typed them in?

 

[Targol]

Instead of storing

textarea.value

in your db, store

Replace(textarea.value, chr(13), &quot;<BR>&quot;)

Water is not bad as long as it stays out human body ;-)

 

[Skittle]

Superb.

Many thanks.