Question on radio button

[Guest]

Hi

Of the items in my form is a radio button group "grpDone" bound to the table's column [Done] datatype "Bit". It has two radio button options "Done" - if selected = 1 and "Not Done" if selected = 0. Default selected is "Not Done"

Our customer now requested this radio button group to not to have default selection and this field is not a required field. So, if neither of the options is selected, in the DB, it has to be a value other than 0 or 1, maybe NULL. I assume "Bit" datatype has to be either a "1" or "0"

I have not worked with MS Access enough to implement this with as little changes as possible (limited time). One thought I have is to change the datatype to Text to store "YES", "NO", "NONE" and figure out how to bind these values to the 2 radio buttons

Any suggestions

 

[Rick B]

Not sure if this is what you want, but we have something similar. I have a
checkbox and i have set it in my form to triple state. You must make it a
number, filed size of single for this to work. You create a checkbox on the
form and set it's truple-state property to true.

Then, you make the check box white or empty to indicate no. You check the
box to indicate yes, and you click it again and the box will turn gray to
indiate n/a.

The values will be null for n/a, 0 for false, and -1 for true.

It works really well for us. We use it to indicate if a client has returned
some checklists to us. In cases where there is no checklist, we mark it
n/a. In cases where theye is a checklist, we start it as clear/no/false.
Once the client has returned it, we mark it true.

On our exception reports, we simply look for values of false (or 0) where
the due date has passed. This prevents the nulls and trues from showing up
on our exception reports.

HTH

Rick B


Hi,

Of the items in my form is a radio button group "grpDone" bound to the
table's column [Done] datatype "Bit". It has two radio button options
"Done" - if selected = 1 and "Not Done" if selected = 0. Default selected
is "Not Done".

Our customer now requested this radio button group to not to have default
selection and this field is not a required field. So, if neither of the
options is selected, in the DB, it has to be a value other than 0 or 1,
maybe NULL. I assume "Bit" datatype has to be either a "1" or "0".

I have not worked with MS Access enough to implement this with as little
changes as possible (limited time). One thought I have is to change the
datatype to Text to store "YES", "NO", "NONE" and figure out how to bind
these values to the 2 radio buttons.

Any suggestions ?

 

[Guest]

Hi Rick

Bingo !

I have to run now and continue my work using your solution later this evening and will post an update as to how it goes

Thank you and much appreciate your input .....