count memo characters

[Allen Browne]

In what context?

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

 

[RoyVidar]

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

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

 

[--- MSh ---]

Hi,
how can count charactrs in memo filed?
thanks

 

[Allen Browne]

Yes: Len(Null) will evaluate to Null.

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

 

[--- MSh ---]

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

 

[David W. Fenton]

You could try concatenating with ZLS

Len(Me!CC & vbNullString)

That will work in code, but you'd need this in a query:

Len(Me!CC & "")