Need to return result to text box from check or formula

D

dtoney

I have a scorecard which needs to produce "pass" or "fail" in an efficient
manner... what is best method?
 
J

John Vinson

I have a scorecard which needs to produce "pass" or "fail" in an efficient
manner... what is best method?
Click to expand...

IIF(YesNoField, "Pass", "Fail")

as the control source of a textbox is one way; another is to use the
Yes/No field as the control source of the textbox and use the "four
value format" trick: set the textbox's Format property to

"";"Pass";"Fail";""

The four formats are for positive, negative, zero and NULL values
respectively; a yes/no field will be -1 for Yes, 0 for No.

John W. Vinson[MVP]
 
Top