
ASP page won't display text from MS Access Memo field
Ryan,
There is an issue with using memo fields from a VBScript page.
You cannot reference the same memo field twice. If you need to be able to
use it more than once in your page then assign the value to a local variable
and use that.
e.g.
This will not work:
if RS("MyMemoField") <> "" then
Response.Write(RS("MyMemoField"))
End If
This will:
MyMemoField = RS("MyMemoField")
if MyMemoField <> "" then
Response.Write(MyMemoField)
End If
Quote:
> Up until this point, all of the text fields in my Access database have
> been of the Text datatype. However, I have a need to increase the
> maximum number of characters in the field above 255 so I changed the
> datatype to Memo. However, for some reason, when I try to retrieve the
> text from the fields now and display it in a standard html page, it
> returns nothing. Is there a different way to retrieve data from a memo
> type field or is there an issue with the Memo datatype in Access? Any
> help would be appreciated. Thanks.
> Sincerely,
> Ryan Bolger