option values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to change the option values to be "male" "female" rather than
"1" "2"?
 
help! said:
Is there anyway to change the option values to be "male" "female"
rather than "1" "2"?
Click to expand...

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.
 
And how do you use the Choose() function? sorry I'm a newbie, thanks so much
for the help!
 
help! said:
And how do you use the Choose() function? sorry I'm a newbie, thanks
so much for the help!
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OptionButton with Bookmark text output 1
Excel Formulas 3
Disallow entry of a form control based on value from another table 8
Multiple IF function 5
Lookup value in table from value in report query 13
If, then 1
yes/no data type custom 2
Getting rid of 0's in report 2

Back
Top