printing 'yes' or 'no' in report rather than check box (1 Viewer)

[kgcrowther]

I was wondering if it were possible to print words in a report rather than having a check box or toggle button.

The reason is that I'm constantly exporting a report to word. It works great except the check boxes never export. It would be better to have words like 'complete' vs 'incomplete' OR 'yes' vs 'no' Does anyone know if this is possible?

Thanks,
Kenneth

 

[Rich]

http://www.access-programmers.co.uk/ubb/Forum5/HTML/001662.html

 

[KeaganQuilty]

kgcrowther,

Instead of putting a checkbox on your report, insert an unbound textbox. In the control source for the textbox, use the IIF function to display what you want.

I.E.

=iif([fieldname]=Yes,"Complete","Incomplete")

Sections are separated by commas. In the first section, you put in a condition for the report to evaluate. The second section is what you want to display if the condition is true, the third is for conditions that are false.

Hope this helps.

Keagan Quilty
Kilbride, Newfoundland