Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Table Design
unchecking check boxes
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="cafe, post: 2541164"] Ok - now it's clear. Set the TripleState property of the checkboxes, to True. Then when you click them, they will cycle between ticked (true), unticked (false), and greyed-out (null). So you can easily "erase" the tick, if you ticked the checkbox accidentally. When TripleState is false, the checkbox will only go from ticked to blank & vice versa. table? If it is a Yes/No type, you're out of luck, because Yes/No fields (in tables) can not contain null vaklues - they are always true, or false - never null. HTH, TC combines different government required questions. Certain questions must be formatted in a certain way with certain coding so that when I query I can export it to a text file and upload. Now, there are some questions that aren't absolutely necessary, but that we do need to gather data on. Our clients at times choose not to answer some of the questions. When our administrative assistant or me will enter these forms into the database form, sometimes we may check yes to question 10, but then realize we accidentally checked yes to 10 and we meant to check yes to question 11. Well, I can't uncheck question 10 and I need to delete the record and start all over because question 10 wasn't answered and we can't make up information to report to the government. Is this more clear? I know there's got to be a way to do this, because every other database I've entered data into I've been able to uncheck a question. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Table Design
unchecking check boxes
Top