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

  • Thread starter Thread starter Dave R.
  • Start date Start date
D

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..
 
Back
Top