Yes/No Fields

[darsana8]

I've imported an excel spreadsheet as a new table in access. One column included yes/no data and this WAS imported into access as a yes/no data-type field. The data is listed either "yes" or "no" for each record. However, I was wondering if there is any way to convert this to show as checkboxes rather than yes/no?

 

[boblarson]

I don't believe so. You should be able to use checkboxes on a form however. You should be using a form for a user interface instead of working directly in a table or query.

 

[Ron_dK]

However, I was wondering if there is any way to convert this to show as checkboxes rather than yes/no?

I think that can be done. Once you've imported your data in Access, go to your table > Yes/no field and change the format of that field to True/False in lieu of Yes/No.



Hth