How to test if a field has not been filled in...

[Dave R.]

I thought I knew the answer to this! I have tried

If ChartNo = Null then
.....

which doesn't work.

Then I try to be sneaky and try

If Len (ChartNo) = 0 then
....

Which didn't work either! How can I write this so that I can see if a field
has been filled in or not? What I am trying to do is I have an unbounded
text box which I am going to write to. This will (I hope) write the empty
field names into the text box. That part is working I just can't figure how
to test for an empty field..

 

[Dave R.]

OK - Just found ISNULL which does this.