immediate if in text box of report

  • Thread starter Thread starter Talbert Vincent
  • Start date Start date
T

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.
 
Talbert Vincent said:
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?
Click to expand...

That expression looks good to me. What is the problem? Make sure that the name of
the Control containing the expression is not "AcceptDate".
 
-----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?
Click to expand...

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

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.
 
Back
Top