Need Null for Option group!

[CEH]

I thought this would be easily found by searching the forum! But I had no luck.
Having trouble with an Option Group. I have an option group with 2 options, YES and NO. Value of Yes set to -1 and value of No set to 0. The field this is bound and is set to Yes/No. The problem is.... No matter what I try it keeps assigning a value to this field in my form! The option group is the last item on the form. Date being the first..... After you enter a date, and an auto number is created, it gives the option group a value of YES or "-1" There is nothing in the default value of the radio button, the frame, or the field to which it is bound. Why is this assigning a value and how can I stop it???? This group needs to remain blank to force the user to THINK before it has a value.
I have managed to get around this by changing the bound field to "Number" instead of a "Yes/No" .... But I am concerned with future queries and filtering. So is this the only way around this problem? Setting the field to "Number"?? And where is it pulling the value of the option group from when I have everything set to null??

Thanks
Curtis

 

[ansentry]

Have you looked in the table to see if the field holding the result has a default value?

I have attached a sample that I created using your set up and I used the wizard to create the option box, set it to NO default and then went and removed the default (0) from the OGResult field in the table.

Post a copy so someone can have a look.

 

[CEH]

John,
Thanks for the look at the post. I looked at your file...... You also have the bound field as "Number" So it works. Maybe I didn't state my question correctly. If you change your field to "Yes/No" it ALSO gives you a default value as soon as a record is created. So the question is..... Is there a way to create a null default value when using "Yes/No" property for the field?

Thanks
Curtis

 

[ansentry]

I am no Access Guru, however I think that with YES/NO you would have to have a default because there is only 2 choices.

I don't see why you would want to have the field in the Table set to Yes/No.

If you have a look at my updated sample you can convert -1 or 0 to Yes No in a query.