Datasheet check box

[Stephanie]

Hello-
I have a subform with a datasheet default view. One of the fields is a check
box. The check box appears "grayed-out" throughout the datasheet, whether the
value is yes or no.

I've set the default value of the check box to 0, thinking that would make
the check box have a white background appearance and then I could see if the
check box is checked or not. But that isn't working. I'd appreciate your
suggestions.

Could I have this check box field state "yes" or "no" appropriately? Could I
have the background color be changed, say to red for "no"? Datasheets are
certainly a different animal!
Thanks for your help!

 

[Bob Quintal]

Hello-
I have a subform with a datasheet default view. One of the fields
is a check box. The check box appears "grayed-out" throughout the
datasheet, whether the value is yes or no.

I've set the default value of the check box to 0, thinking that
would make the check box have a white background appearance and
then I could see if the check box is checked or not. But that
isn't working. I'd appreciate your suggestions.

Could I have this check box field state "yes" or "no"
appropriately? Could I have the background color be changed, say
to red for "no"? Datasheets are certainly a different animal!
Thanks for your help!

If the checkbox is greyed out, it is not bound to the underlying
field in the record source. Either the field name in the control
source of the checkbox is wrong, or the name is a reserved word and
access is trying to use the value of the reserved word.

 

[Bob Quintal]

You are very wise!

Not wise, experienced. If I were wise, I'd never have committed the
same thing, long ago.

Q

 

[Stephanie]

You are very wise!
I was frustrated trying to figure out where in the record source I had gone
wrong- the query was fine, the subform was fine, but the query by form that
didn't seem to need this field stated, most certainly did. Once I included
the field name in the str sql, the check box field shows white, with check
marks. Fabulous! Thanks for your help- much appreciated!