getting a textarea field to work in Access
Posted on 2001-06-25
I can write the data entered in a Form textarea field to the database. I can't get the data back out when reading the Record Set. i.e. if I open the Access database the data has been written to the field HOWEVER not so when reading from the browser.
I have read that there are some issues when dealing with textarea i.e. the larger scrolling fields in a form.
John Kauffman in the book "beginning ASP databases" .
I have tried defining a "notes" field in access as a "Memo" data type and also as a "text" data type.!
Koffman suggests using
getit=newstr(rs("Notes).value) directly after opening the record set.
This is difficult to use in my example when reading out the record set data to the browser:
<TEXTAREA name="Notes" rows=3 cols=50 value="<%= MyRs("Notes")%>"></TEXTAREA></TD>