How To?: Display Checkbox as yes / no on a report

[LaCour]

Is it possible to display a checkbox as "Yes" or "No" on a report? Null (if applicable) would also display "No"

Thanks in advance
Blair

 

[groundclutter]

Put a textbox on the report...set the control source to your yes/no field....set the format to "Yes/No"...

GC

 

[LaCour]

Groundclutter ... thanks ... your suggestion will yield the numeric value 0 for False anything else is True.

I declared a textbox and am using the following in the control source to evaluate the return value. I knew it would be something like this ... I was initially checking to see if the field was true or false, but Access "likes" to deal with 0 and -1 in this case.

For anyone doing something similar use this.
=IIf([YourBooleanYesNoField]=0,"No","Yes")