ACC: Only One Button Accepts Selection in Yes/No Option GroupLast reviewed: May 28, 1997Article ID: Q97510 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When a form contains an option group with two option buttons, and the values of the option buttons are set to values 0 and 1 respectively, and the option group is bound to a Yes/No field in a table, only the option button with value 0 can be selected.
CAUSEIn Microsoft Access, the value 0 represents FALSE, and any other value represents TRUE. In a field of data type Yes/No, TRUE values are assigned the value -1. If you click an option button that has a value of 1, the Yes/No field to which the option group is bound is changed to -1, or TRUE. The option button attempts to put the value 1 into the Yes/No field. But because the field is of data type Yes/No, the field is set to -1 for any value other than 0. Because the value of the option button is set to 1 and the Yes/No field now contains a -1, the button does not appear to be selected.
RESOLUTIONChange the option value for the second button from 1 to -1.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
|
Additional query words: radio button
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |