Option Group for gender

[hamidchi]

Hi
.
I wanna use option group in a form for choosing gender(male,female)


but option group returns number instead of the words "male" or "female"

how can I have these words in gender column when I press male or female button ?

------------------------------
P.S:
I read somewhere that the solution is to add a text box and then invisible it and bound it to the gender column
and . unbound the option group and in property sheet after update . write a code for changing numbers 1 and 2 with words male and female

please help what code i should write ?

[alansidman]

In the properties for the option group, change the values, however in your table, what difference does it make. If you need the result in a query or report, then add an expression to the query that converts it to the appropriate text and hide the value field that contains 1 or 2.

[pbaldy]

Not at a computer, but if memory serves the option values can only be numeric. An example of an expression:

=IIf(FieldName = 1, "Male", "Female ")

[CJ_London]

and if you have more than 2 options, use the choose function


choose(fieldname,"Male","Female","Robot")