yes/no boxes from table become 0s and -1s in Labels

[Guest]

I have mutliple fields as check boxes in my access database. When I try to
make labels of these records these fields show up as 0s and -1s on the label.
I would like to know whow to create a label where the data comes across as
yes and no.

 

[Guest]

When you create your query - try using an immediate if statement. Something
like the following where [Checkboxfield]=the name of your field in [].

IIf([checkboxfield]=true,"Yes","No")

This should convert a true value to "Yes" and a false value to "No".

Hope that helps

 

[Guest]

I typed this exactly in the querey criteria, and it would not proceed. I am
not unfortunately very familiar with the SQL code. Is there somthing
obviously wrong with the following? (Active is the name of this particualr
field)

IIf([Active]=true,"Yes","No")

 

[Jason Lepack]

It shouldn't be typed in the Criteria row, it should be typed in the
Field row.

Cheers,
Jason Lepack

 

[Guest]

That did it!! Thank you. I was able to customize them even further with
that formula. That is great.

It shouldn't be typed in the Criteria row, it should be typed in the
Field row.

Cheers,
Jason Lepack

I typed this exactly in the querey criteria, and it would not proceed. I am
not unfortunately very familiar with the SQL code. Is there somthing
obviously wrong with the following? (Active is the name of this particualr
field)

IIf([Active]=true,"Yes","No")