Memo Field Lenght

  • Thread starter Thread starter RickCass
  • Start date Start date
R

RickCass

How do I determine the length of a memo field?

I am trying to setup a delete query.

I can't figure out how to determine if the field,
called "lineDescription", is blank.

How do I determine the length of a memo field?

CornFuz'd
 
In the Field row of your query, enter:
HowLong: Nz(Len([lineDescription]), 0)
and in the Criteria row under this, enter:
0

A better solution would be to open the table in design view, and set the
Allow Zero Length property for this field to No in the lower pane. You could
then select the records with nothing in the memo field simply by putting
this in the Criteria row under the memo:
Is Null
 
Back
Top