How do I format checkboxes for reporting

[Steve]

Hi,

I can select the populated checkboxes in a query by testing for 'True", that
works fine. But when I report them, they display as -1 or 0, how can I
format them into a more meaningful format for a report?

Thx!

Steve

 

[Marshall Barton]

I can select the populated checkboxes in a query by testing for 'True", that
works fine. But when I report them, they display as -1 or 0, how can I
format them into a more meaningful format for a report?

Depends on what you think is "a more meaningful format".

If you want to display some text such as Yes or No, then set
the text box's Format to something like
"";"Yes";"No"

You could change the text box to a check box so it looks the
same as in a form, but that doesn't look so good in a
report.

Then there's ...