Yes/No field appears as -1/0

  • Thread starter Thread starter Igor
  • Start date Start date
I

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.
 
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.
Click to expand...

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.
 
Thank you very much, John.

--

igor


John W. Vinson said:
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.
Click to expand...
 
Back
Top