CR in Memo Fields

[ggrewe]

I have a database with a memo field that collects a large amount of data. When data is input into the memo field, people are using Carriage Returns in the text box. However when viewing the data or generating reports, the CR is not present and the data returns as one long string.

Can someone help me correct this?

 

[Bastien]

use the replace function to change the CRLF to <br> to create a break in the line..do a search here to find examples of the code...

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[ggrewe]

Thanks Bastien;

Do I do the replacement when I submit the data to the db or when I retrieve it? I am trying to make it happen when I retrieve the data, but no luck yet. Thanks.

 

[codestorm]

To save time ..
Response.write replace(obj_Recordset.Fields(&quot;MyMemoField&quot, vbcrlf, &quot;<br />&quot codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[Bastien]

I would do replace it when the items are placed into the DB


hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[codestorm]

My preference is to keep text in a fairly neutral format in the database and format it when extracting it - you might not always want to bring it out as HTML. codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>