Access 2003 Syntax for empty text box?
Posted on 2006-07-11
I have to following in a text box in a report in Access 2003:
="Revised Date" & " " & Format([crpProduct_RevisedDate],"mmmm dd"", ""yyyy")
What I want to be able to do though is if this date values is empty don't show the text box on the report other wise if it does contain a date show its value. I was wondering if there is syntax like an if statement i can put in the control source to do this or do I have to set visible and not visible for the text box in the code behind the report?
Which is the best way? I would prefer to do it in the control source but not too sure of the syntax. In the code behind i have something similar done already.
Thanks again in advance for all the help.