How do I change report output based on field content

T

Tinee

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
 
J

Jeff Boyce

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
 
M

Marshall Barton

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