 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / September 2007Datasheet check box
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! > Hello- > I have a subform with a datasheet default view. One of the fields [quoted text clipped - 10 lines] > 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.  SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com 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! > > Hello- > > I have a subform with a datasheet default view. One of the fields [quoted text clipped - 15 lines] > 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. > You are very wise! Not wise, experienced. If I were wise, I'd never have committed the same thing, long ago. Q SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.