control source problem

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

Guest

I have some dates coming into my report but I need to print "TBD" (to be
determined) if the dates are blank. what is the syntax to do this? I've tried
everyting but all I get is #ERROR on the report.
The fields are date/time and my control format is 'short date'.
My latest attempt was:
=IIF(isnull([mydate]),"TBD",[mydate])

-David
 
You might try using the control's format property.

Format: mm/dd/yy;mm/dd/yy;mm/dd/yy;"TBD"

I'm not sure that the format I posted is correct - and I am on a computer that
doesn't have Access so I can't check it.

Also,make sure that your control is not named MyDate and you can probably use
the formula you have proposed vice setting the format.
 
Back
Top