stop automatic data filling in combo boxes

  • Thread starter Thread starter Selam
  • Start date Start date
S

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?
 
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" έγγÏαψε:
 
No.It is a Yes/No field with no default value.

George said:
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" έγγÏαψε:
Click to expand...
 
You may be right. But is it possible to write few codes so that I could erase
the default value?
 
You may be right. But is it possible to write few codes so that I could erase
the default value?
Click to expand...

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