displaying a memo in a textarea

jhunta · #1 (**permalink**) June 8th, 2003, 06:27 PM

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

KenSchaefer · #2 (**permalink**) June 9th, 2003, 11:04 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tab function + <textarea></textarea>	Adam H-W	HTML Code Clinic	0	April 24th, 2007 10:36 AM
Displaying textarea content to html table	keithc	Pro PHP	2	December 1st, 2006 03:12 AM
Memo field not displaying	meichmann	SQL Server ASP	3	August 31st, 2006 11:36 AM
problem displaying text fron Db to textarea	mail4nrs	Classic ASP Databases	4	August 20th, 2004 08:31 AM
display vbCrLf's from textarea to textarea	mat41	Classic ASP Basics	8	June 10th, 2004 12:19 AM