Option Groups

[bdehning]

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.

 

[Rick Brandt]

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.

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

=Choose([YourField],"Excellent", "Good", "Average", "Fair", "Poor")

 

[John Vinson]

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.

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.