losing yes/no data

[rkapfer]

I noticed that I'm losing data (luckly it's test data) whenever I import or export! If I export a table from one database to another the resulting databases table has lost any yes/no fields. In datasheet view the resulting table has zero's (0) or -1. I find the same thing happening if I export the table to Excel then Import it into anoter database or table. Have you a clue.

 

[Jon K]

The resulting table is displaying the Yes/No field with text boxes: 0 means No and -1 means Yes.

You can control how the field is displayed by changing the Format and Display Control in the General and Lookup tabs in table Design.

 

[rkapfer]

I noticed this also ocurrs as a result of a Make Table Query. The resulting table does have as you said has the 0's an -1's (instead of neat check box's). The resulting table's definition has Yes/No specified but the data still appears as 0/-1 in any query. Is there any flag, option or control required to hold the format?