
Not applicable
2012-05-16
08:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field looks like it is blank but isnull function does not work
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
9,245 Views
1 Solution
Accepted Solutions


MVP
2012-05-16
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
if( len(trim(FIELD))=0, ..
or
if( len(trim(purgechar(FIELD, chr(160)))) = 0,...
instead of
if( isnull(FIELD), ...
3 Replies

Anonymous
Not applicable
2012-05-16
10:31 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If isnull() doesn't work, you can try trim(field)=''
This will test for blank fields.
-Phil
4,586 Views

.png)
Luminary Alumni
2012-05-16
10:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
4,586 Views


MVP
2012-05-16
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
if( len(trim(FIELD))=0, ..
or
if( len(trim(purgechar(FIELD, chr(160)))) = 0,...
instead of
if( isnull(FIELD), ...
