Results 1 to 4 of 4
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Checkbox Always Shows Checked

    I am using a linked SQL Server Table as the control source for my form. The column that I have based the check box on is a bit column in SQL Server i.e. a Yes/No field in access. I have added the check box to my form, it is set like so


    Visible = Yes
    Locked = No

    But anytime I try to input data the checkbox just shows a square inside the check box and I can not click or unclick this record. What did I set-up incorrectly?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    The square box inside the checkbox control indicates the value of the control is undetermined, aka Null.

    Checkbox controls are tri-state. They can be Yes(-1), No(0), or Null.

    If your table is linked, using the Bit field in SQL server as the control source of your checkbox should not be an issue. If IIRC, 1 is Yes and 0 is No with the Bit data type and Access will make adjustments. I would check that there is an actual value, 0 or 1, stored in that record you are viewing via your Access form.

  3. #3
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    Quote Originally Posted by ItsMe View Post
    The square box inside the checkbox control indicates the value of the control is undetermined, aka Null.

    Checkbox controls are tri-state. They can be Yes(-1), No(0), or Null.

    If your table is linked, using the Bit field in SQL server as the control source of your checkbox should not be an issue. If IIRC, 1 is Yes and 0 is No with the Bit data type and Access will make adjustments. I would check that there is an actual value, 0 or 1, stored in that record you are viewing via your Access form.
    That was it, there were a few null values in my table that I updated to 0s

    Thank you!

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    No problem

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-21-2016, 11:38 AM
  2. If checkbox is checked allow query to run
    By burrina in forum Forms
    Replies: 14
    Last Post: 01-29-2013, 03:56 PM
  3. VBA for testing if checkbox is checked
    By rhewitt in forum Programming
    Replies: 0
    Last Post: 09-26-2012, 07:11 AM
  4. Display Text Only if Checkbox is Checked
    By Rick5150 in forum Forms
    Replies: 2
    Last Post: 09-16-2012, 09:19 AM
  5. If checkbox is checked, add X to a current value
    By INeedAboutTreeFiddy in forum Programming
    Replies: 4
    Last Post: 05-30-2012, 08:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums