I am having a problem displaying data from a memo field in a text area.
I use the following code to populate the textarea which produces mixed results.
replace(rs.Fields.Item("kk_Memo"),Chr(13) & chr(10),"<BR>")

Sometimes it returns part of the text to the text area, but it includes the <br>'s. Other times, the textarea is completely blank.

Anyone have any ideas where I am going wrong?

Thanks,
jeff

See http://support.microsoft.com/default.aspx?scid=200124 (Accessing SQL Server Text or Access Memo field returns no data in ASP).

You should be using the .GetChunk() method to extract the data from the Access Memo field.

Cheers
Ken

www.adOpenStatic.com