Yes/No fields

[Guest]

I have two tables: customer and employee. Each has a field [Inactive],
formatted as Yes/No, Indexed (dupes ok).

When viewing table data, why does one show checkbox and the other show Yes
or No? They work correctly in queries, forms, reports. I am exporting and I
need it to be Yes or No. One does, one doesn't and they truly appear to be
setup the same.

Does anyone know?

 

[Jeff L]

Look at the design of your table, select your Yes/No field and then
click on the Lookup tab down in the bottom where the field properties
are. My guess is that one is set to Checkbox and the other is set to
Textbox.

Hope that helps!

 

[Guest]

Thanks Jeff!

That was the issue. Now solved.
--
Thanks for your help,
Chris

Look at the design of your table, select your Yes/No field and then
click on the Lookup tab down in the bottom where the field properties
are. My guess is that one is set to Checkbox and the other is set to
Textbox.

Hope that helps!

I have two tables: customer and employee. Each has a field [Inactive],
formatted as Yes/No, Indexed (dupes ok).

When viewing table data, why does one show checkbox and the other show Yes
or No? They work correctly in queries, forms, reports. I am exporting and I
need it to be Yes or No. One does, one doesn't and they truly appear to be
setup the same.

Does anyone know?

 

[Duane Hookom]

You might want to check the Format properties. I would probably use a query
with explicit expressions like:

NewColumnName: IIf([Inactive],"Yes","No")