Check the default setting of the button.

Signature
KARL DEWEY
Build a little - Test a little
> 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.
Donna - 08 Apr 2008 21:05 GMT
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.
> Check the default setting of the button.
>
[quoted text clipped - 4 lines]
> >
> > Thanks for your help.
Donna - 08 Apr 2008 21:10 GMT
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.
> Check the default setting of the button.
>
[quoted text clipped - 4 lines]
> >
> > Thanks for your help.
KARL DEWEY - 08 Apr 2008 21:35 GMT
Do you have 'a' (singular) radio button or options buttons that displays Yes
for on and No for another?

Signature
KARL DEWEY
Build a little - Test a little
> 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
[quoted text clipped - 8 lines]
> > >
> > > Thanks for your help.
Donna - 08 Apr 2008 21:45 GMT
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.
> Do you have 'a' (singular) radio button or options buttons that displays Yes
> for on and No for another?
[quoted text clipped - 11 lines]
> > > >
> > > > Thanks for your help.
KARL DEWEY - 08 Apr 2008 21:57 GMT
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.

Signature
KARL DEWEY
Build a little - Test a little
> 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.
[quoted text clipped - 14 lines]
> > > > >
> > > > > Thanks for your help.
> 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.
A yes/no field in a table cannot hold a value except yes or no. even if
you leave the default blank, when the record is created, it will
contain the value 0, which represents no.

Signature
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **