Writing a text area to a recordset.

[sbalun]

I'm having trouble writing the contents of a text area to an MS Access recordset. This is the code I'm currently trying to use:

rs("Question_6") = cstr(request.form("increaseEffectiveness"))

increaseEffectiveness is the name of the text area.

All I'm getting is the first word of whatever sentence is being written in the text area. What I need is the entire sentence.

I appreciate the help.

Have a positive day,
--Scott

 

[JrClown]

Make sure the Access field is greater than 21 bytes QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>