[RESOLVED] in my formula I need to hide a text object placed in details section

Hi,
I have a text object including a command field from my database. When the command field is equal to certain value like, more precisely when it s equal to:
"12/31/9999" , I want to hide that text object ie replace it with space character.

How do I reference the text object in my formula editor, and how do I make it hidden?

Thanx.

Instead of a text object use a formula field

Code:

---

If {Table1.Command}="12/31/9999" then " " else "Text"

---

yes but instead of "Text" I want a date. I guess that gives an error, since the empty string "" doesn t match a date, which guves an error.
Thnx

Try (replace CurrentDate by your date) :

Code:

---

If {Table1.Command}="12/31/9999" then Date(0,0,0) else CurrentDate

---

thnx a lot, works miraculasly :)