Radio Button Default Value Problem

[Donna]

I have a yes/no field set up in a table and on a form as a radio button
group. I have the default value in the table set to be nothing, but every
time I open the form to add a new record, the default value of NO is
selected. What am I doing wrong?

Thanks for your help.

 

[KARL DEWEY]

Check the default setting of the button.

 

[Donna]

I'm not finding a place for a default value on a button. I see where to put
it for the group (under data tab) but it's blank there.

 

[Donna]

When I open the form to a NEW record, the radio buttons are blank, but as
soon as I enter data into any field on the form, even before getting to the
radio button field, it already has the NO button marked.

 

[KARL DEWEY]

Do you have 'a' (singular) radio button or options buttons that displays Yes
for on and No for another?

 

[Donna]

It's an option group with 2 buttons, one value is 0 and one value is -1. The
control source is the yes/no field in the table.

 

[KARL DEWEY]

Open the form in design view and click on the frame that surrounds the radio
buttons (not on a button) and check the default setting.

 

[indigotima]

Does this mean that it is impossible to set up a situation where you have a
yes/ no option box with no default until the user selects an option?

Would anyone have a work-around to suggest? When there's a default
selected, my users tend not to address the question and I need them to
conciously select "yes" or "no".

Regards.

 

[Bob Quintal]

Does this mean that it is impossible to set up a situation where
you have a yes/ no option box with no default until the user
selects an option?

Would anyone have a work-around to suggest? When there's a
default selected, my users tend not to address the question and I
need them to conciously select "yes" or "no".

Regards.

you can change the table from a yes/no field to an integer type and
allow nulls, you then modify the option group to respond to the
integer equivalents of true (-1) and false(0) the null will appear
greyed out.

Q

 

[indigotima]

And if I'm trying to change a yes/no field within an previously existing
database, how woudl changing field type affect already existing entries?
Would it nullify them?

Thank you.

 

[Bob Quintal]

And if I'm trying to change a yes/no field within an previously
existing database, how woudl changing field type affect already
existing entries? Would it nullify them?

Thank you.

No it would not nullify the existing entries. If you need nulls
reset, you would need to add a new column to the table design, then
decide which ones are no and which are null, and copy over the valid
yesses and valid noes.

HTH

Q