Converting a check box to Yes or No in report

[Johnny Drama]

This is probably so simple that I'm overlooking it, but I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out.

Thoughts?

Thanks in advance!

 

[pbaldy]

Try a textbox control source of:

=IIf(FieldName = -1, "Yes", "No")

 

[Johnny Drama]

You, sir, are the man. Thanks for the quick response!

 

[pbaldy]

Happy to help!