How to show checkboxes as YES/NO-statements in reports?

[Fredrik831]

Hi,

I'm trying to create a report that shows if an article is in stock or not. The table for the underlying data uses a checkbox for each record if it's in stock. However, when I'm creating the report based on that data, it simply shows the checkbox, if it's clicked or not. I would like to replace the checkbox in the report with a YES/NO-statement. Could someone give me some advice on how I could achive that?



Thank you in advance!

[pbaldy]

Try a textbox with a control source of:

=IIf(FieldName = True, "Yes", "No")