Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Isnull or null question in formula

Status
Not open for further replies.

sonar1

Programmer
Mar 22, 2002
2
CA
I'm using the following
IF ToText ({EComp.EmDateEnd} ) = "" or Isnull({EComp.EmDateEnd} ) - I have used this statement before - now all the sudden EmdateEnd - which appears to be null is not processing properly - any thoughts.
I've tried every variation I can think of.
 
Did you try putting the IsNull expression first in the comparison....

IF Isnull({EComp.EmDateEnd}) or ToText ({EComp.EmDateEnd} ) = "" ?

I have read that this seems to make a difference.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top