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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query criteria in a memo field 1
Memo fields not displaying in query 4
Dates in a memo field 3
Memo fields in a query 4
Make Table Query Truncating Memo Field at 255 Characters 2
disctinct query memo field 3
Selecting Distinct Memo Fields 1
Querying memo fields. 5

Back
Top