Prev: simple ?- unable to edit text box quandry
Next: DISABLE printing by Ctrl-P
From: Mark Kubicki on 18 May 2010 18:54
how come (?) when I enter the expression:

=Len(Nz(Me.txtAuthor, 0))
it returns the value 1 even when the field is blank !

much thanks, in advance, for any thought you may have
-m.


From: Dirk Goldgar on 18 May 2010 20:27
"Mark Kubicki" <Mark(a)TillotsonDesign.com> wrote in message
news:%23c8%23g0t9KHA.3176(a)TK2MSFTNGP05.phx.gbl...
> how come (?) when I enter the expression:
>
> =Len(Nz(Me.txtAuthor, 0))
> it returns the value 1 even when the field is blank !


Yes, that would be correct. What you have written says, "If Me.txtAuthor is
Null, take the number 0, convert it to a string -- "0" -- and tell me the
length of that string. The result will be 1.

You may want this:

=Len(Nz(Me.txtAuthor, ""))

or this:

=Len(Me.txtAuthor & "")

.... which will accomplish the same thing.

Or you may want something else, if I've guessed wrong about what you intend
with this expression.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 | 
Pages: 1
Prev: simple ?- unable to edit text box quandry
Next: DISABLE printing by Ctrl-P