Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Radio Button Default Value Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Donna - 08 Apr 2008 19:21 GMT
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 - 08 Apr 2008 20:41 GMT
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.
Bob Quintal - 09 Apr 2008 01:03 GMT
> 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 **

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.