changing option group value to something meaningful

[RipperT]

Hello,

I have an option group on a form that users select tween two choices. The
form says "Male" and "Female", but the values stored in the table are "1"
and "2". In my queries and reports, how can I get the values to show as
"Male" and "Female" again?

Many thanks,

Ripper

 

[Rick Brandt]

Hello,

I have an option group on a form that users select tween two choices.
The form says "Male" and "Female", but the values stored in the table
are "1" and "2". In my queries and reports, how can I get the values
to show as "Male" and "Female" again?

Many thanks,

Ripper

=Choose([FieldName], "Male", "Female")