Yes/No fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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!
 
Thanks Jeff!

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


Jeff L said:
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?
Click to expand...
Click to expand...
 
You might want to check the Format properties. I would probably use a query
with explicit expressions like:

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