Replace blank date field with Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to replace a null value date field in a report with "See Below".
Can I do this in the report itself?
 
Add anoher text box to the report, and set its Control Source to something
like this:
=IIf(IsDate([MyDate], Format([MyDate], "Short Date"), "See Below")

Replace "MyDate" with the name of your date field.

You may need to leave the MyDate text box on the report for this to work.
Just set its Visible property to No if you don't want to see it as well.
 
You should also be able to do this with the Format Property
Format: m/d/yyyy; ; ;"See Below"
 
Back
Top