Need to return result to text box from check or formula

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

Guest

I have a scorecard which needs to produce "pass" or "fail" in an efficient
manner... what is best method?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Help... Again. 3
Text Box with Pass/Fail result 1
populate and update textbox 1
return a message to a text box based on a calculation 1
drag formula down making chgs on the way (Q2) 5
Sheet name determined by cell value in INDEX/MATCH 2
Excel Macro to Modify Multiple Worksheets in the Same Manner 1
Help with ISERROR 2

Back
Top