Output DB memo with line returns 1

[ukwebsite]

I have a form that inputs some data into a access database. The field that it inputs to is a memo field.

How do I output the info like it was inputted on the form e.g.

This is a sample
This is on the next line


But it comes out like this


This is a sample This is on the next line


When you open the database the data is on two lines but it only outputs on 1 line. Please help

Thanks Matthew Wilde
matthew@ukwebsite.com

 

[FesterSXS]

When you output the info back to the screen use this:

strText = Replace(objRecordset(&quot;MemoField&quot;),vbcrlf,&quot;<BR>&quot;)

Response.Write strText

This replaces all the line breaks in the Memo field with valid HTML line breaks. Tony

http://www.phoenix-paints.co.uk/portfolio

 

[ukwebsite]

Works perfectly. Thanks very much. Matthew Wilde
matthew@ukwebsite.com

 

[ukwebsite]

That worked good but what about tabs? Matthew Wilde
matthew@ukwebsite.com

 

[Tarwn]

Do the same thing, replace the character code for tab with something like

"    "

. It's cheap, it's dirty, but it also works
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation

 

[ukwebsite]

whats the character code for tab? Is there a way to find out character codes Matthew Wilde
matthew@ukwebsite.com