custom formatting for check box values in reports

[coline]

Hi, I would like to display data in a report that is based on check-box data entry, so the values in my table are 0 or -1. I have used the format property in the report to display these values as "Yes" or "No". However, ideally I would only like to display a "X" or "Yes" when checked and blank when unchecked. Is there any way to custom format how check boxes display in reports?

Thanks so much,
Coline

 

[SydneyGeek]

Not directly, but you could use a textbox instead, with an expression like:
=Iif([myChkBox]=TRUE,"Yes","") -- adjust checkbox name to suit

Denis