converting to yes/no data type

[dj982020]

I have several yes/no columns in my table. I exported my table to a text cleaning application to clean some memo fields of non-printable characters and when I imported the table back into Access, the yes/no fields showed up as (0) and (-1).

Do you have any idea how I can get them back to check boxes?

Thanks,
~DJ

 

[BNPMike]

Whatever query you are using to view the table, you can amend the properties of the field in question in the QBE Grid so that it is formatted as a check box.

Don't view tables directly. It is bad practice.