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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I create a Conditional to test if Text exists or not

Status
Not open for further replies.

computek353

Technical User
Feb 21, 2002
29
US
I need to selectively hide data and cannot figure out how to test if the data exists in a formula. Can anyone Help?
 
isnull({fieldname}) is the key. It will return true if the field is null and false if it is not. I have had to use length({fieldname})>0 in some cases, I am not sure why.

There are also functions for IsNumeric, IsDate, IsDatetime, etc. These may be of help.

Let me know if you have any questions.
Software Support for Macola, Crystal Reports and Goldmine
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top