Option Groups

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

Guest

I have several option groups with choices from 2-5 on several forms. Option Groups display numbers in tables and queries and not text.

What is the best way to convert these numbers into text

For example I have an Evaluation Field with 1 for Excellent, 2 for Good, 3 for Average, 4 for Fair and 5 for Poor.
 
bdehning said:
I have several option groups with choices from 2-5 on several forms.
Click to expand...
Option Groups display numbers in tables and queries and not text.
What is the best way to convert these numbers into text?

For example I have an Evaluation Field with 1 for Excellent, 2 for Good,
Click to expand...
3 for Average, 4 for Fair and 5 for Poor.

For short lists starting at 1 the Choose function would be the easiest.

=Choose([YourField],"Excellent", "Good", "Average", "Fair", "Poor")
 
I have several option groups with choices from 2-5 on several forms. Option Groups display numbers in tables and queries and not text.

What is the best way to convert these numbers into text?

For example I have an Evaluation Field with 1 for Excellent, 2 for Good, 3 for Average, 4 for Fair and 5 for Poor.
Click to expand...

Create several "translation" tables with two fields: a number and a
text value, e.g.

1 Excellent
2 Good
3 Average
4 Fair
5 Poor

Either create a Query joining your table to each of these tables by
the number field, and displaying the text field; or replace the Option
Group controls on your Form with listboxes or combo boxes based on
these tables.
 
Back
Top