Hello,

I'm saving a textarea value from a form into an Access DB. When the textarea info hits the Comments field, which has a datatype of Memo, it is not updated. However, if the Comments field is set to a datatype of Text, the info is saved. But, it will only save up to 255 characters. I want to use Memo to save a long message. How can I get my data saved with a datatype of Memo? Here's the code that updates the Comments field of each record.

'objRS is the recordset, Comments is the filed, and
'finformation is the value of the textarea.
objRS.Update "Comments", finformation

Any help? Thanks.

textarea=request("textarea")

set cnn=Server.CreateObject("ADODB.Connection")
cnn.Open Application("cnn_ConnectionString")
sql = "update tablename set fildname='"&textarea&"'"
cnn.Execute(sql)


surendran
(Anything is Possible)