How to get blank dates to print as "TBD"

[Guest]

I have a report that prints dates (they come in from a table column which is
date/time). In certain circumstances, when the dates are blank, the user
wants me to print "TBD". I have tried various ways to achieve this to no
avail , nothing seems to work. Any help appreciated.
-David

 

[Rick B]

Use the Nz function in an unbound text field to replace a null value with
something else.

=Nz([SomeDateField],"TBD")

 

[fredg]

I have a report that prints dates (they come in from a table column which is
date/time). In certain circumstances, when the dates are blank, the user
wants me to print "TBD". I have tried various ways to achieve this to no
avail , nothing seems to work. Any help appreciated.
-David

Simply use the control's format property.
Set the control's format property to:

mm/dd/yyyy;mm/dd/yyyy;;"TBD"

See Access help on Format property + Number and Currency datatypes.

Change the mm/dd/yyyy to what ever other format you wish the date to
display as.