Defaulting a Required Yes/No field to Blank

  • Thread starter Thread starter DoctorV3774 via AccessMonster.com
  • Start date Start date
D

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
 
DoctorV3774 said:
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.
Click to expand...


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.
 
Back
Top