YES/NO values - HELP!

[Joao]

I have a table with various fields, one of them YES/NO. I formated it using:
;"Sim"[Black];"Não"[Red] with a TextBox display control.

Now, when I fill a grid with some sql function, the data that appears in
that field is 0 for No and 1 for Yes. Why it doesn't assume the formatted
values?

 

[Rick Brandt]

I have a table with various fields, one of them YES/NO. I formated it
using: ;"Sim"[Black];"Não"[Red] with a TextBox display control.

Now, when I fill a grid with some sql function, the data that appears
in that field is 0 for No and 1 for Yes. Why it doesn't assume the
formatted values?

Format properties are strictly applied to the object where you enter them.
If you did this in the table design you are telling Access "When I view this
table's datasheet on the screen, I want the format to be this". It does not
cause the table to send the data in that format on to queries, forms, or
reports that might use the table as an input. You have to repeat the format
in all places where you look at the data.

The exception is that the wizards for creating forms and reports will in
some cases copy the format properties applied at the table level to the new
form or report being created. It is the wizard that is doing that though
and not some basic behavior of the format property.