How to check if a database field has no value at all?

[Blamdude]

I can access two fields in my database called status.ref and status.hat. They are free form fields in which you can type anything you want, numbers, text etc.

If I have a new invoice opened and I never put anything into either one of those fields then Length({status.refno}) and Length({status.hat}) returns nothing at all. Not even a zero. Once I put any text into the fields I get a value returned using Length as expected. If I clear out the fields then I get a value of zero when using Length. Somehow the field doesn't even really exist unless I put something into it.

How do I check if there is no value at all? I need to check for this condition so I can properly calculate the amount owed by the customer.

Any questions by all means ask.

Thank you all very much,

dave

 

[kskid]

use IsNull({TABLE.FIELD})