report text box format

E

edhead

I have a text box in a report where the control source is field that
contains either a 1 or a 0. I am trying to setup the format of the text
box to display Fail for a 0 value and Pass for a 1 value but I can't
figure out the syntax for the format. Thanks in advance for any help!
 
M

Marshall Barton

edhead said:
I have a text box in a report where the control source is field that
contains either a 1 or a 0. I am trying to setup the format of the text
box to display Fail for a 0 value and Pass for a 1 value but I can't
figure out the syntax for the format. Thanks in advance for any help!
Click to expand...


Try this in the text box's Format property:

"Pass";"Fail";"Zero";"Null"
 
F

fredg

I have a text box in a report where the control source is field that
contains either a 1 or a 0. I am trying to setup the format of the text
box to display Fail for a 0 value and Pass for a 1 value but I can't
figure out the syntax for the format. Thanks in advance for any help!
Click to expand...

Use an unbound control instead.
Set it's Control Source to:
=IIf([FieldName] = 1,"Pass","Fail")
 
Top