How do I uncheck a checkbox?

[mjw]

I've created a bound checkbox on a subform with a default value of 0
and no validation rules. I should be able to check and uncheck this
checkbox by clicking in it, right? I'm not able to uncheck it. What
am I doing wrong?

 

[golfinray]

Your check box is bound to a yes/no, or binary field? If so, make sure your
checkbox properties are not set to enabled = no. I would look at the other
properties as well just to make sure you don't have something weird setup.

 

[ruralguy via AccessMonster.com]

You will also want to make sure the RecordSource of the SubForm is updateable.

 

[mjw]

My field is a bit field. Enabled = Yes. I can't find anything in my
properties that looks wrong.

 

[Dirk Goldgar]

I've created a bound checkbox on a subform with a default value of 0
and no validation rules. I should be able to check and uncheck this
checkbox by clicking in it, right? I'm not able to uncheck it. What
am I doing wrong?

Is the subform bound to an updatable query or table? Is the check box bound
to a field, not an expression? Is the subform's AllowEdits property set to
Yes? Is the parent form's AllowEdits property set to Yes?

 

[mjw]

You will also want to make sure the RecordSource of the SubForm is updateable.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1

I'm able to update all the other fields on this subform. Does that
mean it's updateable? Where do I check this at? Is it a form
property?

 

[ruralguy via AccessMonster.com]

What is the BackEnd of your db? Is the SubForm bound to a query? Can you
change that field in the query?

You will also want to make sure the RecordSource of the SubForm is updateable.

[quoted text clipped - 8 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1

I'm able to update all the other fields on this subform. Does that
mean it's updateable? Where do I check this at? Is it a form
property?

 

[mjw]

My subform is bound to a table that is updateable.
My checkbox is bound to a bit field in this same table.
My subform Allow Edits = Yes
My parent form Allow Edits = Yes

 

[mjw]

The backend is SQLServer.
The subform is bound to a table that is updateable.

What is the BackEnd of your db? Is the SubForm bound to a query? Can you
change that field in the query?

[quoted text clipped - 8 lines]
I'm able to update all the other fields on this subform.  Does that
mean it's updateable?  Where do I check this at?  Is it a form
property?

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1

 

[ruralguy via AccessMonster.com]

I don't know what conversion Access makes for a BIT field. Can you make a
query or view of the table and then change the BIT field? If so, can you then
bind the query/view to the form instead of the table directly?

The backend is SQLServer.
The subform is bound to a table that is updateable.

What is the BackEnd of your db? Is the SubForm bound to a query? Can you
change that field in the query?

[quoted text clipped - 16 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1

 

[golfinray]

Is the checkbox in the field list? If it is, I would delte that field from
the table, delete the checkbox, and start over.
--
Milton Purdy
ACCESS
State of Arkansas

My subform is bound to a table that is updateable.
My checkbox is bound to a bit field in this same table.
My subform Allow Edits = Yes
My parent form Allow Edits = Yes

 

[mjw]

I've got it working! I don't know why, but when I change the datatype
of my field (that the checkbox is bound to) in the table from a bit
datatype to an int datatype and then re-create the checkbox, it
works. I can now uncheck the checkbox. Geez! Thanks to everyone for
helping.

 

[John W. Vinson]

I've got it working! I don't know why, but when I change the datatype
of my field (that the checkbox is bound to) in the table from a bit
datatype to an int datatype and then re-create the checkbox, it
works. I can now uncheck the checkbox.

A Checkbox has two values: 0 for unchecked, -1 for checked. -1 is a valid Int
value but it is NOT a valid Bit value (which can be 0 or 1 only).

 

[ruralguy via AccessMonster.com]

Thanks for posting back with your success.

I've got it working! I don't know why, but when I change the datatype
of my field (that the checkbox is bound to) in the table from a bit
datatype to an int datatype and then re-create the checkbox, it
works. I can now uncheck the checkbox. Geez! Thanks to everyone for
helping.

Is thecheckboxin the field list? If it is, I would delte that field from
the table, delete thecheckbox, and start over.

[quoted text clipped - 27 lines]