immediate if in text box of report

[Talbert Vincent]

I have a date in my table that is the default date of
1/1/1900. I do not want the user to see the date. I just
want them to see a blank. I am trying to use a immediate
if statement. This is what I am working with.
=IIF([AcceptDate]=#1/1/1900#,"",[AcceptDate])

What am I doing wrong?

Thank you in advance for the help.

 

[Rick Brandt]

I have a date in my table that is the default date of
1/1/1900. I do not want the user to see the date. I just
want them to see a blank. I am trying to use a immediate
if statement. This is what I am working with.
=IIF([AcceptDate]=#1/1/1900#,"",[AcceptDate])

What am I doing wrong?

That expression looks good to me. What is the problem? Make sure that the name of
the Control containing the expression is not "AcceptDate".

 

[Talbert Vincent]

-----Original Message-----

I have a date in my table that is the default date of
1/1/1900. I do not want the user to see the date. I just
want them to see a blank. I am trying to use a immediate
if statement. This is what I am working with.
=IIF([AcceptDate]=#1/1/1900#,"",[AcceptDate])

What am I doing wrong?

That expression looks good to me. What is the problem? Make sure that the name of
the Control containing the expression is not "AcceptDate".

Thank you,
Well, idiot me I did not change the name of the control.
After I changed it everything worked.
Thanks again for the assistance.