G
Guest
Is there anyway to change the option values to be "male" "female" rather than
"1" "2"?
"1" "2"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
help! said:Is there anyway to change the option values to be "male" "female"
rather than "1" "2"?
OptionGroup values must be numeric. You can use the Choose() function to
translate the numbers to text for display or you can use a format property if
you make one of the numbers zero or negative.
G
Guest
And how do you use the Choose() function? sorry I'm a newbie, thanks so much
for the help!
for the help!
R
Rick Brandt
help! said:And how do you use the Choose() function? sorry I'm a newbie, thanks
so much for the help!
If I had a field that contained numeric values 1, 2, 3 then to use Choose() to
output "one", "two", and "three" I could use...
=Choose([FieldName], "one", "two", "three")
Check the help file on the Choose() function for more details. Also the related
Switch() function.
G
Guest
=Choose(Me.MyOptionGroup, "Male", "Female", "Other")