Checkbox field on form

[PatB]

I have a front end access application that is linked to a sequel server
database. I had a programmer add a checkbox field to that table, which shows
in my access table as a Yes/No data type, with lookup set as Text (just like
the other checkboxes that are in this table and appear on the form). I've
dragged the field onto the form, and it displays correctly as a checkbox both
in design and form view, but when I look at the table or run a query, the
check isn't recognized and comes across as 0 instead of -1. I've been
working on this for hours and really need HELP!

 

[bcap]

Sounds like the check box on the form is unbound. Make sure that it's
Control Source property contains the name of the correct field in the table.

 

[Pat B]

Took awhile to respond back as my developer was trying to work it out on the
sequel server end. The field was bound with the correct properties. The
only way I've gotten it to work is for the developer to change the Data Type
to Number, with a field size at Long Integer. A field name of
accessTimestamp was also added. The checkbox works but I have to treat it as
a Yes or No in a query or report, and then the results appear in a checkbox
in the field column results. I then have to create an expression to convert
it to Yes or No. It also will not allow me to make changes to the properties
of other fields in the table (won't let me save changes), which I was able to
do previously. Just would like to know why all the other checkboxes on the
same data form work fine and all have the same properties of Yes/No, yet this
one would not work the same.