Reporting Check box values

[GloriaLuz]

Hello,
This is a simple question.

In my application I have the option of selecting different check boxes (6 different options). My database is storing the values 0 and -1 for nonchecked - checked boxes as it should be.

Now, I would like to create a report to display which values were selected from the options above but I don't know how to do it as if I display the values, I will only get -1 and 0.

Is there a way I can convert again or I can give the check boxes other values in order to be able to report them with their original names ?

Thank you
Gloria

 

[Rich]

You can have True/False, Yes/No or
=Iif(MyField,"SomeText","SomeOtherText")

What exactly do you want to appear?

 

[KurtL]

You can have True/False, Yes/No or
=Iif(MyField,"SomeText","SomeOtherText")

What exactly do you want to appear?

Rich how would i get -1 to appear as YES and 0 to appear as NO? Im a noob to Access. Would i do this in the query?

Thanks
Kurt

 

[Rich]

Change the display format to Yes/No or True/False, but then queries aren't really designed for viewing