Yes/No Check Box Not Saving

[Guest]

I've got Access 2000 and in a table created a Yes/No field that was formatted
as a check box. Initially, it displayed fine so I saved it and exited. Now,
when I come back to the database the field is always showing -1/0 instead of
the check box. I have gone back, corrected and saved the table (over and
over again). It always shows the check box correctly after I modify and save
the table, but after I close and re-enter the table it's back to the -1/0
format. Why can't I get it to save as a checkbox? More important, can I fix
this permanently?

 

[John Vinson]

I've got Access 2000 and in a table created a Yes/No field that was formatted
as a check box. Initially, it displayed fine so I saved it and exited. Now,
when I come back to the database the field is always showing -1/0 instead of
the check box. I have gone back, corrected and saved the table (over and
over again). It always shows the check box correctly after I modify and save
the table, but after I close and re-enter the table it's back to the -1/0
format. Why can't I get it to save as a checkbox? More important, can I fix
this permanently?

A Yes/No field in a table is in fact stored as -1 for True, 0 for
False.

It shouldn't matter a bit how your table datasheet displays the field!
Generally, table datasheets should not be used for data display or
data entry, but only for debugging.

Create a Form based on your table - with a checkbox control bound to
this field - and use *it* for interaction with your table data.

John W. Vinson[MVP]

 

[Guest]

It shouldn't matter a bit how your table datasheet displays the field!
Generally, table datasheets should not be used for data display or
data entry, but only for debugging.

Create a Form based on your table - with a checkbox control bound to
this field - and use *it* for interaction with your table data.

I have to apologize for sounding stupid, but I'm confused.

1) Check boxes in other tables I have created with Yes/No fields actually
display in the tables as check boxes. The fact that this one does something
different from the others makes me wonder if I've done something that
inhibits the table from showing check boxes.

2) I understand when you say the table display shouldn't matter, yet when I
do create a form it will not display as a checkbox. Yes/No, True/False,
On/Off, will show but never a checkbox option. I'm dragging the object
straight into the form from the field list. Am I missing something?

 

[John Vinson]

2) I understand when you say the table display shouldn't matter, yet when I
do create a form it will not display as a checkbox. Yes/No, True/False,
On/Off, will show but never a checkbox option. I'm dragging the object
straight into the form from the field list. Am I missing something?

Yes: the Toolbar.

Select the Checkbox (or radio button, if you wish) tool on the
Toolbox; then drag the field from the field list. Or, just select the
checkbox control, place it on the form where you want; if the magic
wand icon on the toolbar is selected, Access will ask what field
should be used.

I'm not sure why the choice of control in the Table view isn't
"sticking", but it does NOT dictate or limit the choice of form
controls.

John W. Vinson[MVP]