testing for empty memo field

How should I write a test for Access memo field to see if it is empty?
I have tried:

IF(Recordset1.Fields.Item("duty2").Value)<>" " then
Response.write"2. "& (Recordset1.Fields.Item("duty2").Value)& "<br>"
else
response.write"2. Empty"
end if


this way will properly print the numeral indicated if the field is not empty
but will not print the contents of the field. What am I missing?
Thanks
Durwood

You're only missing the fact that memo fields can only be retrieved once on a
page. StrDuty = Recordset1.Fields.Item(&quot;duty2&quot.Value If StrDuty
&lt;&gt; &quot;&quot; Then Response.Write(&quot;2. &quot; &amp; StrDuty &amp;
&quot;&lt;br&gt;&quot Else Response.Write(&quot;2. Empty&quot End If

Thanks

Jon Spivey sent me this explanation of your idea:
To get memo fields to display correctly you need to name them last in your

sql and then assign them to a string before printing them, so
%
set rs=Connection.excute("select field1, memofield from table")
str= rs(1)
if str & "" <> "" then
' empty
else
' not empty - write it out
end if
%

Jon

"cmbergin" <webforumsuser (AT) macromedia (DOT) com> wrote

You're only missing the fact that memo fields can only be retrieved once
on a
page. StrDuty = Recordset1.Fields.Item(&quot;duty2&quot.Value If
StrDuty
&lt;> &quot;&quot; Then Response.Write(&quot;2. &quot; &amp; StrDuty
&amp;
&quot;&lt;br>&quot Else Response.Write(&quot;2. Empty&quot End If