checkboxes in report

[nia]

Hiya folks..
Just wondering is there any way i can display the result of my checkbox from my form as a simple YES or NO in my report, instead of the standard checked or blank box.
Thanks
Nia
(",)

 

[ColinEssex]

Use the IIf statement might be an idea.

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

Col

 

[Rich]

Delete the original checkbox, add a textbox, set its control source to the original yes/no field, set the data type to Yes/No