changing option group value to something meaningful

  • Thread starter Thread starter RipperT
  • Start date Start date
R

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
 
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
Click to expand...

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