Microsoft KB Archive/97510

= ACC: Only One Button Accepts Selection in Yes/No Option Group =

Article ID: 97510

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q97510



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
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.



CAUSE
In 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.



RESOLUTION
Change the option value for the second button from 1 to -1.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) In a form, create an option group for a Yes/No field in a table.
 * 2) Add two option buttons to the group.
 * 3) Set the option value for Button1 to 0.
 * 4) Set the option value for Button2 to 1.
 * 5) View the form in Form view. Note that any attempt to click Button2 fails.

Additional query words: radio button

Keywords: kbprb kbusage KB97510

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.