Adding an Option Group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form on a database that is used to edit records. I added an option
group with yes/no values after there were several existing records. Prior to
this addition, I do not want this field to show "yes" or "no". I want it to
be null. But, on the pre-existing records, they are displaying "no". What
do I need to do in order for the pre-existing records to show as null and the
records added after this addition to show what the user chose?
 
If it is checked it will by yes, if it is empty it will be no. To my
knowledge you can't set the box to reflect null. I know VB has a tri-state,
which allows for indeterminate. I do not remember off hand if Access has
this capability.
 
Janet said:
I have a form on a database that is used to edit records. I added an option
group with yes/no values after there were several existing records. Prior to
this addition, I do not want this field to show "yes" or "no". I want it to
be null. But, on the pre-existing records, they are displaying "no". What
do I need to do in order for the pre-existing records to show as null and the
records added after this addition to show what the user chose?
Click to expand...


A Yes/No field is incapable of being Null. If you change
the field to an Integer instead, then it can be null. A
check box bound to an integer field will display as checked
(Yes) if the field's value is not zero. Be sure to
understand the control's TripleState property. Also note
that you can not preserve the Yes/No field's data without
preserving the 0 values it already has.

I am bothered by your use of the term "option group". An
Option Group contains multiple option check boxes, radio
buttons or option buttons, which have no value. THe option
group as a whole has a value, but it is not normally a
Yes/No value.
 
Back
Top