stop automatic data filling in combo boxes

[Selam]

I have a form which is meant for data entry. It has 8 combo boxes which are
set to yes/ No fields. Each combo box is a 2-column combo box and its row
source is: -1;"Yes";0;"No". When I tried to add a record in on of the fields
it fills the other feilds with NO. I want to stop ithis automatic data
filling. Help?

 

[George]

Dear Salam,

I am guessing that the field is a number field. If so, then check at the
properties of this field in the form - remove the default value 0 appearing
there

GeorgeCY

Ο χÏήστης "Selam" έγγÏαψε:

 

[Selam]

No.It is a Yes/No field with no default value.

Dear Salam,

I am guessing that the field is a number field. If so, then check at the
properties of this field in the form - remove the default value 0 appearing
there

GeorgeCY

Ο χÏήστης "Selam" έγγÏαψε:

 

[John W. Vinson]

No.It is a Yes/No field with no default value.

A Yes/No field cannot be NULL: it's either Yes or No, and No is the default.

 

[Selam]

You may be right. But is it possible to write few codes so that I could erase
the default value?

 

[John W. Vinson]

You may be right. But is it possible to write few codes so that I could erase
the default value?

Not while you're using a Yes/No field, no. Once you dirty the record by
editing ANY other field, a Yes/No field will be No unless specified otherwise.

You can change the datatype to Integer or Byte and manually maintain the three
valued logic (e.g. 1 = Yes, 0 = No, Null), but you can't use a Yes/No field.