Is Null

  • Thread starter Thread starter George L.
  • Start date Start date
G

George L.

Tried to avoid Is Null by making field called Title;
Required & Allow Zero Length.
Above works fine with Query Criteria.
Attempted,in report,to see if I could use IIF function,as
follows:
=IIF([Title]<>" ","Not Blank","Blank")

I keep getting #Error in Title field of report.

Please show me how I can determine if field is Zero
Length, so I can initiate another action, in the report.

Thanks!

George
 
Why are you trying to avoid the use of Is Null? If a field is actually null,
it isn't equal to anything.

On the other hand, if the field can be Null, or a zero-length field (or even
contain blanks), you can use the following:

=IIF(Len([Title] & "") > 0,"Not Blank","Blank")
 
George said:
Tried to avoid Is Null by making field called Title;
Required & Allow Zero Length.
Above works fine with Query Criteria.
Attempted,in report,to see if I could use IIF function,as
follows:
=IIF([Title]<>" ","Not Blank","Blank")

I keep getting #Error in Title field of report.

Please show me how I can determine if field is Zero
Length, so I can initiate another action, in the report.
Click to expand...


Another thing that might be causing you trouble is if the
text box is named Title. This would be a circular reference
since the text box has to know its value to calculate its
value. If that's part of your problem, just change the name
of the text box to something else such as txtTitle.
 
Back
Top