How do I change report output based on field content

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

Guest

I need to produce a report with output based on a field entry in the table.
ie if field has content then substitue value with the word "Supplied", if no
content then leave it blank
 
Base your report on a query. In the query, use the IIF() function to
"convert" a value of ... (I couldn't tell) to "Supplied", and to either Null
or "" if not).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Tinee said:
I need to produce a report with output based on a field entry in the table.
ie if field has content then substitue value with the word "Supplied", if no
content then leave it blank
Click to expand...


The simplest thing to do is to use the text box's Format
property. Check Help on the Format Property (and its links)
for details on the different types of values. For a numeric
value the Format property would be set to:
"Supplied";;;""

You could also get the desired effect by using a control
source expression =IIf(field Is Null, "", "Supplied"), but
if the text box is involved in any calculations, the
calculations won't work.
 
Back
Top