count memo characters

A

Allen Browne

In what context?

In a query, you could type something like this into the field row in query
design:
Len([MyMemo])
 
R

RoyVidar

--- MSh --- said:
If Len(Me.CC) = Null Then
is it true?
value len a memo can be null when it was empty?
Click to expand...

Null is unknown, so also the length will be unknown.

You could try concatenating with ZLS

Len(Me!CC & vbNullString)

Or test for Null with the IsNull function

If IsNull(Me!CC) Then
' it's Null
Else
' it's not Null
End If
 
A

Allen Browne

Yes: Len(Null) will evaluate to Null.

If you wanted zero, use:
Nz(Len(Me.CC), 0)
 
M

--- MSh ---

If Len(Me.CC) = Null Then
is it true?
value len a memo can be null when it was empty?
 
Top