Displaying an asterick in a text box of a report.

C

CyndyG

I have a table containg a list of tapes that were sent out. When these tapes
have been returned I would like an asteric to be displayed by each returning
tape in a texbox on a report.
tblTapes hold the field for the tapes. Only field on that table are:
reqid,tape number, and receive date.
 
B

Brendan Reynolds

Something like this in the Control Source of the text box should do it ...

=IIf(IsNull([receive date]), "*", "")

See IIf Function and IsNull Function in the help file for details.
 
Top