Defaulting a Required Yes/No field to Blank

[DoctorV3774 via AccessMonster.com]

I have a field in my table where the data type is Yes/No and it is a
required field. The user wants the default value for the control to be
blank yet whenever we go to a new record the default value shows up as No.
Can you set a Yes/No field that is required to default to blank? There are
no default values set at either the control or table field level.

Thanks

 

[Marshall Barton]

I have a field in my table where the data type is Yes/No and it is a
required field. The user wants the default value for the control to be
blank yet whenever we go to a new record the default value shows up as No.
Can you set a Yes/No field that is required to default to blank? There are
no default values set at either the control or table field level.

A Yes/No field can only have a value of True or False, not a
blank or Null.

However, if you make the field an Integer instead of Yes/No,
then you can bind it to a check box control on your form.
Then you can set the control's TripleState property to get
it to display as a grayed out blank when the field is Null.