Yes/No field handling in Form

[Guest]

I have other fields on the form along with the Option Group for handling
Yes/No field. The Recod Source of the form is attached to the table. My
problem is that when I enter a new record and insert any value in other
fields, the Option Group automatically gets the value of False or NO. I want
to instruct the user to insert either Yes or No. The default value of Yes/No
field is not set in table as well as on the form.

 

[Dirk Goldgar]

I have other fields on the form along with the Option Group for
handling Yes/No field. The Recod Source of the form is attached to
the table. My problem is that when I enter a new record and insert
any value in other fields, the Option Group automatically gets the
value of False or NO. I want to instruct the user to insert either
Yes or No. The default value of Yes/No field is not set in table as
well as on the form.

A Yes/No field, in a Jet database table, can never be Null -- it is
always True or False, with False as the default, whether you want a
default value or not. The only way around this for you is to use an
Integer field instead, and limit it to the values -1 (true), 0 (false),
and Null.