October 29, 200322 yr Newbies Hi, I have a few check box fields (define value lists) set up in my databases where I would like to have the box "auto filled" upon record creation. One box is ([ ] Yes [X] No), and I would like the "no" box checked upon creation of the record. This is easy for me to do with drop down menus but I have not been able to figure out how to do it with check boxes. Am I missing something really basic here? Any help is appreciated. Thank you. Steve F.
October 29, 200322 yr In your field definitions, double-click on the field you want to modify. Under the Auto-Enter tab, enter No in the 'Data' section. Personally, I would use 1/0 instead of Yes/No, have it auto-enter 0, and only show the user a single checkbox, formatted with just enough room to display the box and nothing else. A check would then be considered 1 (Yes) and clicking it again would remove the data (No).
Create an account or sign in to comment