Memo fields

takabyte · October 31st, 2003, 06:03 PM

I have an Access database with a table using a memo field. I am able to store data into that field, and I am able to retrieve and display data from that field. However, I cannot test the field for contents before displaying. Once I have applied an "if" statement to the field contents, it's as though the field is now empty. Displaying it with a response.write statement results in no data being displayed. Is ther a way around this problem?

Samples:
response.write("Show me " & rs("memo")
'displays the data perfectly

if rs("memo")>""
response.write("Show me " & rs("memo")
end if
' displays only the "Show me "

The same problem occurs no matter what method is used to determine whether the field has any content. Merely accessing the field seems to render future accesses impossible.

Jonax · October 31st, 2003, 06:12 PM

Have you tried assigning it's value to a variable?

Code:

sMemo = rs("memo")
if sMemo <> "" then
  response.write "Show me " & sMemo
end if

Imar · October 31st, 2003, 06:13 PM

Hi there,

This is a bit odd indeed, and looks a bit like other known issues with BLOB fields (http://support.microsoft.com/default...NoWebContent=1).

One thing to work around this, is to assign the value of the BLOB Memo) field to a variable and use that in your code:

Code:

Dim BodyText
BodyText = rs("memo")
If Len(BodyText) > 0
  Response.Write("Show me " & BodyText)
End If

This way the Memo field is only accessed once, while you still have full functionality.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.