Douglas J. Steele said:You can either set the Control Source for the textbox on your report to
=Nz([MyDateField], "...")
(including the equal sign: replace MyDateField with the appropriate field
name)(
or you can create a query that has a computed field as above (without the
equal sign in the query), and use the query as the Record Source for the
report.
--
Doug Steele, Microsoft Access MVP
(No private e-mails, please)
Mike said:I have a table that has dates in it. When I print a report from that table,
it leaves the date field empty if the date was not inputted. I need it to
print "..." if there is not a date there. How do I do it?
[email protected] said:try this...
replace the date field in the report design with a text
box containing the following expression:
=IIf(IsNull([mydate]),"...",[mydate])
where mydate is the name of your date field. You could
just as well use "not input" or any other " " string in
place of "...", perhaps to give the user more info about
the status of the date field for that record.
Hope this helps
-----Original Message-----
I have a table that has dates in it. When I print a report from that table,
it leaves the date field empty if the date was not inputted. I need it to
print "..." if there is not a date there. How do I do it?
.