Displaying an asterick in a text box of a report.

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

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Can Import Excel. 1
Calculate conditiona total at bottom of continuous form. 4
Accessing dropdownlists in a datalist control 1
Macro to produce a report from a query 3
Acoustics - 80Hz loss in car! 0
Text from List Box in report header 4
Highest value for a field 2
Can't get text box on report to display all of text. 3

Back
Top