Change Data for Check Box

[Guest]

I have a database that i use check boxes to track completion of certain
stages of the order, so that I can print a report and see what has been done.
However the default data for check check boxes when check enters a -1 into
the table. I would like to know if there is a way to mask that data in the
report so it shows up as a check or an x, something other than a number.

 

[Rick B]

To show as a check, just use the "checkbox" control.

To show as an "x" make an IF statement in an unbound text box and show "x"
if true and "" if false.

Rick B