How can I get a Yes No option group to default to neither value.

[ToyFox]

I have an option group (with a Yes No ) field.
When the form loads for a new record, the fields all default to NO. Is there a way to have it default to neither or blank.

 

[dhookom]

Try remove the default in both the table and the form.

Duane
Hook'D on Access
MS Access MVP

 

[ToyFox]

I'll double check that -- but I don't think there are any default values.

 

[ToyFox]

I don't have any default values. When I selected the option group from the toolbox, I definitely selected no default value....It is defaulting to NO. Is there a workaround? thx

 

[PHV]

Why using an option group with yes,no instead of a checkbox ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

I just tested this with an option group and two buttons
[tt][blue]
Caption Value
======= =====
Yes -1
No 0
[/blue][/tt]
I made sure there was no default for the option group and the bound field in the table. When I viewed new records, neither of buttons was selected. Then I changed the field's default value in table design to 0 and the option group then defaulted to No.

Duane
Hook'D on Access
MS Access MVP

 

[ToyFox]

I got it gang. In this application the developer has a routine that defaults all controls to default values. So if there is an optiongroup is defaults to 0.
I simply have to remove it from the case statement.

Thanks for your help.