Re: How to get blank dates to print as "TBD"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

=Nz([SomeDateField],"TBD")


--
Rick B



"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:57F8A330-6844-4BF2-9599-9AA488C0EAC4@xxxxxxxxxxxxxxxx
>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


.

Relevant Pages

  • Re: Entering miscellaneous information into a report
    ... That should not happen if it is in an unbound text box. ... that when the report comes up after I go through these dialog boxes it ... "Rick B" wrote: ... going to be used as a packing slip, sent with equipment that has been ...
    (microsoft.public.access.reports)
  • Re: how to view binary field in access
    ... Rick B ... > I use Access to link to my SQL Server tables to write a report. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Can a user enter a value for a txt box on a rep as it opens
    ... Thanks for your help Rick. ... > Just build an unbound text box and put the following in it... ... >> user types into an Input dialog box to appear on the report. ... If you want to limit records on the report based on the user's ...
    (microsoft.public.access.reports)
  • Re: adding underscore _ in output field
    ... unbound text field like... ... Rick B ... > I need to add an underscore in a field that currently has a space. ... John Smith need to output to a report to read John_Smith. ...
    (microsoft.public.access.reports)
  • Re: Can a user enter a value for a txt box on a rep as it opens
    ... Just build an unbound text box and put the following in it... ... > user types into an Input dialog box to appear on the report. ... >> Rick B ... >>> that he sees fit as the report opens. ...
    (microsoft.public.access.reports)