Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear QV users,
I would like to use the isnull function for a field, but the field looks like it's blank, but isn't.
Are there other functions to solve this?
With kind regards,
Aissam
Try
if( len(trim(FIELD))=0, ..
or
if( len(trim(purgechar(FIELD, chr(160)))) = 0,...
instead of
if( isnull(FIELD), ...
If isnull() doesn't work, you can try trim(field)=''
This will test for blank fields.
-Phil
Aissam - You can also use IsText() and IsNum() boolean functions to evaluate the field value. Does it show the '-' in the field value?
Cheers,
DV
Try
if( len(trim(FIELD))=0, ..
or
if( len(trim(purgechar(FIELD, chr(160)))) = 0,...
instead of
if( isnull(FIELD), ...