Yes/No field appears as -1/0

[Igor]

Hello,

I have a Yes/No field but in all queries and reports it appears with the
value -1/0.

I need that it appears as Yes/No. How can I do this?

Thanks in advance.

 

[John W. Vinson]

Hello,

I have a Yes/No field but in all queries and reports it appears with the
value -1/0.

I need that it appears as Yes/No. How can I do this?

Thanks in advance.

It shows as -1 or 0 because *that is the actual value of a yes/no field*. This
is not a bug, this is not an error; this is what is actually in your database.

In a Report, set the Format property of the textbox bound to the yes/no field
to "Yes/No" (this is one of the options in the format dropdown).

In a Query datasheet... well, don't use query datasheets to display anything.
That's not their purpose. If you must do so, set the Format of the field to
Yes/No.

 

[Igor]

Thank you very much, John.

--

igor

It shows as -1 or 0 because *that is the actual value of a yes/no field*. This
is not a bug, this is not an error; this is what is actually in your database.

In a Report, set the Format property of the textbox bound to the yes/no field
to "Yes/No" (this is one of the options in the format dropdown).

In a Query datasheet... well, don't use query datasheets to display anything.
That's not their purpose. If you must do so, set the Format of the field to
Yes/No.