Editing One Field Changes Another Field

[bgong]

I have a simple form with just a text box and a check box. Both
controls are bound to its own field in a table. Both fields are not
'required' and both have no default values. When I create a new
record, the textbox is blank and the check box shows gray since its
value is Null. So far, so good. However, as soon as I type anything
in the textbox, the checkbox gets cleared and its underlying value
gets set to false. Is this normal behavior? Is there any way I can
edit the textbox without having the checkbox change value behind my
back?

Any help, suggestions, would be appreciated. Thanks.

bgong

 

[Allen Browne]

If the check box is bound to a Yes/No field in a JET (Access) table, it has
only 2 values: True or False. It cannot be Null.

If you want a triple-state field (yes/no/null), you will need to make it a
Number field in table design.

There are other reasons why you may want to do that too:
http://allenbrowne.com/NoYesNo.html