Grey box inside the checkbox

[darkhat01]

I have a checkbox that has a grayed out box inside of it. What causes this/ what is it? I looked up the record and there should be a checkmark in the box. In the table it is set to have one.

I know that if the prefeances of Enables is set to No then all of the check box and the text label box is all grayed out, But in my case it is only the inner part of the box…. (And it is a Checkbox…)

The box name is ABC1 and it just reads the record, that’s it... It is used for reports later down the road. So there is not any code set to this check box.

Anyone have any ideas?

Thanks,

Darkhat01

 

[pbaldy]

The inner part being gray implies that the data behind it is null. I see checked for true, white for false, and gray for null. Are you sure you're bound to a field that's true?

 

[darkhat01]

Ok it is going to the right record, but I am still getting a "null" as it is called.

Question: If the record is blank, this would be null right? 1 is on 0 is off nothing is null... There is a check mark in this record... What would cause this problem with null?

 

[gemma-the-husky]

yes, if you dont set an initial state for the bnound field it will initialize as null in a new record.

 

[darkhat01]

NEW Update:

I'm getting an error message on the checkbox that I never noticed before in Access that states "control can't be edited; it's bound to unknown field 'ABC1'."

Now this Field does exist, and there is no space before or after the ABC1.

So this is why it is grayed out, because the system is setting it to null.

Any new ideas what I could try?

 

[jkl0]

Check the properties of the check box for Triple State (should be set to no for just checked or not checked).
If already set to no try deleting the checkbox (on your form) and reinsert it.

 

[gemma-the-husky]

if its an unknown field, then the field name you are using does not exist in the query source. Open the properties and select the correct field source from those available.

 

[darkhat01]

First off I would like to thank everyone that responded to this thread.

Everything you all suggested got me closer to figuring it out what was going on.

The resolution: It was the code. The person that added the ABC field did not add any code in for it. As I am, she was new to Access.

Thank you so much,

Darkhat01