[RESOLVED] How to change Boolean field from displaying "0" and "-1" to "Yes" and "No"

[sugardaddy]

Hey there,

I have a data report, which displays a few fields from an Access table, one which is a boolean. At the moment if the boolean value is True, then on the data report it displays "-1", and if False "0".

How can I change this so it displays "Yes" if true and "No" if False?

Would be really grateful for any help.
Thanks.

[litlewiki]

hey just use a small if condition that checks whether the value of record is 0 or 1 and correspondingly display as true or false

[sugardaddy]

hey just use a small if condition that checks whether the value of record is 0 or 1 and correspondingly display as true or false

Could you by chance post the coding, or syntax, for the smallif condition?

[CVMichael]

I don't know how you display the data, using SQL statements, or bound controls...

With SQL statements, you do it like this:

SELECT IIF(my_bool_val = True, 'Yes', 'No') FROM my_table WHERE ..........etc....

[sugardaddy]

I found a solution: simply change the Format of the boolean in Properties, which allows you to state a value for True and for False.

Nevertheless, thanks Wiki and Michael