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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS access forms list box problems 1
conditional punctuation in a report 3
Yes/No Display 8
Access how do you set a yes/no data type as required? 0
Access Dcount (multiple criteria) 3
Yes/No field-How to fix 3
Yes/No without (-1) 7
Check Boxes Yes/No 1

Back
Top