How do I chk if memo field is empty? 1

steve728 · Jun 1, 2003

I'm used to using the following:

If rs.fields("Memo&quot

.value <> "" Then
Process code ...
End If

Thank you Cyber Buddies!

Steve

WB786 · Jun 1, 2003

Try this:

If Len(Nz(rs.fields, "&quot

= 0 Then
Process code ...
End If

WB

jfischer · Jun 2, 2003

To catch both Null and Zero-length:

Code:

If rs.Fields(&quot;Memo&quot;).Value & &quot;&quot; = &quot;&quot; Then
  'Process code...
End If

steve728 · Jun 2, 2003

Thank you! Thank you!
These suggestions did the trick!

Steve

jfischer · Jun 2, 2003

Sorry, I didn't catch your "<>". My example should be:

Code:

If rs.Fields(&quot;Memo&quot;).Value & &quot;&quot; <> &quot;&quot; Then
  'Process code...
End If