 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006Yes/No field check box
I have a yes/no field in my table. I have created a form for this table, but the control for this field shows up as a text box. How can I change this to be a check box, so that when the user checks the box the field in the tabls shows as "yes" or "true"? How did you generate the check box on your form? Did you view the field list and drag the check box control to your form? If not, have you changed anything on the table on the lookup tab? did you select text box there? it should be check box. > I have a yes/no field in my table. I have created a form for this table, but > the control for this field shows up as a text box. How can I change this to > be a check box, so that when the user checks the box the field in the tabls > shows as "yes" or "true"? Thanks so much for this response - I went back and checked how my field was set up and realized I had set it up as a text box, so I changed it to checkbox. That allows me to add the check box control to my form, but now I have a new problem - when I try to use the form, I cannot check or uncheck the box. I do not even get an error message, so I'm not really sure wha the problem is. Any ideas? > How did you generate the check box on your form? Did you view the field list > and drag the check box control to your form? If not, have you changed [quoted text clipped - 5 lines] > > be a check box, so that when the user checks the box the field in the tabls > > shows as "yes" or "true"? Sorry, I didn't notice you had re-posted, have you still got problems but guess you must have sorted them by now????? > Thanks so much for this response - I went back and checked how my field was > set up and realized I had set it up as a text box, so I changed it to [quoted text clipped - 12 lines] > > > be a check box, so that when the user checks the box the field in the tabls > > > shows as "yes" or "true"? Just add a CheckBox to the form, then just set its ControlSource property to be the field you want to bind it to. Also set its DefaultValue property to True (yes) or False (no), as appropriate. Regards, Graham R Seach Microsoft Access MVP Canberra, Australia --------------------------- >I have a yes/no field in my table. I have created a form for this table, >but [quoted text clipped - 3 lines] > tabls > shows as "yes" or "true"? |
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.