I would like to display Memo data type field of Access database into a HTML table. Is it possible to do that. Can someone let me know if there could be any problems in doing so?<BR><BR>Thank You for your help
Yes you can do it. For example<BR><BR>sMsg = objRS.fields("myMemo").value - set the variable to your memo field<BR>' some table stuff here<BR><td><%=sMsg%></td><BR><BR>There are more optimal ways of doing it, but that should give you a start.
You may also want to try<BR><BR>xQry = "SELECT memoFld FROM table WHERE tid=" & intid<BR>Set xRS = Conn.Execute(xQry)<BR>strBigField = xRS.GetString()<BR><BR>Where memoFld is the memo datatype column you want<BR>tid is the id field in the DB<BR>intid is the value used to determine which record you need