report text box format

  • Thread starter Thread starter edhead
  • Start date Start date
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!
 
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"
 
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")
 
Back
Top