create a yes/no with option button

[amra01]

ok i know this question seems silly but i am a complete newbe....

here is the problem:
i want to create 2 option buttons
one for YES and one for NO
i want to store a specific value (NAI means YES in Greek and OXI means NO that is why i can't use the yes/no data field)
when i press the one option button i want to store NAI (means YES)
and when i press the other one i want to store (OXI means NO) in the same field.

 

[Fuga]

I think you should use the yes/no field. It stores -1 for yes and 0 for no (or if it´s the other way around). You don´t have to display "yes" or "no" on your form. Just put a label or something there that says "nai".

I don´t think you need two fields if you just need yes or no.

Fuga.

 

[Mile-O]

Don't create two option buttons; create an Option Group. Then follow the wizard through.

Bind the option group frame to a long integer field in your table.

 

[amra01]

thanks a lot for your quick response fellas

if i use option group it stores only numbers, but i want to store text and not numbers.

if i use a check box instead of 2 option box and use yes/no
it stores yes or no
but it makes it less functional for the user....

 

[Mile-O]

Yes, it stores numbers which take up less space than alphabetical characters.

When you open the form on that record again, if the option group field is bound to the field, then it will set the option group's value to Nai or Oxi dependant.

Or you could use a textbox with the Choose function.

=Choose([OptionGroup], "Oxi", "Nai")

 

[amra01]

When you open the form on that record again, if the option group field is bound to the field, then it will set the option group's value to Nai or Oxi dependant.

Or you could use a textbox with the Choose function.

=Choose([OptionGroup], "Oxi", "Nai")

i don't get it how this is hapening?
sorry...

 

[Mile-O]

Quick example

 

[amra01]

thanks a lot for the file you sent me...
sorry for bothering you so much...
but i want the stored value to be a text NAI or a text OXI because when i 'll create a report i want to show text and not a number....

i am sending you the database...with yes and no...

 

[Mile-O]

Do you see the function in the textbox? The function is:

=Choose([fraYesNo], "Oxi", "Nai")

It is calculated from the numerical value in the field.

On your report you can put a textbox bound to the number and set it's Visible value to false.

Another textbox on the report can contain the function. No need to store the value in the table.

 

[amra01]

db2.mdb

 

[amra01]

i see....you are right
thanks a lot i think this is solved....

 

[amra01]

ok here is what i did it is very simple...
the field should be text...
then in the form create an option group

the values will be a number 1 and 2 for each option button select the field as the one that you want to store the value.
if you check it it stores 1 or 2 now go back at the table at lookup
set these values:

display values: combo box
row source type: value list
row source : 1;"NAI";2;"OXI"
column count : 2

and it's done.