How do I uncheck a checkbox?

  • Thread starter Thread starter mjw
  • Start date Start date
M

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?
 
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.
 
My field is a bit field. Enabled = Yes. I can't find anything in my
properties that looks wrong.
 
mjw said:
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?
Click to expand...


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?
 
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
 
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]
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1
Click to expand...
Click to expand...
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?
Click to expand...

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

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200905/1
Click to expand...
 
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


mjw said:
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
Click to expand...
 
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.
 
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.
Click to expand...

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).
 
Back
Top