Display Option Group label name versus value

[Guest]

I created a form with an option group. I later created a report based off of
a querie that draws from a table that the form is tied to.

My report draws the actual value (1,2,3 or 4) from the table, and not the
label name (text) that I want

i.e. 1= Freshman
2=Sophomore
3=Junior
4=Senior

I want the text to show up in the report - NOT the values.

Any help would be appreciated!!

Thank you!

 

[fredg]

I created a form with an option group. I later created a report based off of
a querie that draws from a table that the form is tied to.

My report draws the actual value (1,2,3 or 4) from the table, and not the
label name (text) that I want

i.e. 1= Freshman
2=Sophomore
3=Junior
4=Senior

I want the text to show up in the report - NOT the values.

Any help would be appreciated!!

Thank you!

In the report, add an unbound text control.
Set it's Control Source to:
=Choose([OptionGroupName],"Freshman","Sophomore","Junior","Senior")

 

[Marshall Barton]

I created a form with an option group. I later created a report based off of
a querie that draws from a table that the form is tied to.

My report draws the actual value (1,2,3 or 4) from the table, and not the
label name (text) that I want

i.e. 1= Freshman
2=Sophomore
3=Junior
4=Senior

I want the text to show up in the report - NOT the values.

Change the query to join to the table that contains the
label names.

If you currently have the table field as a lookup field with
a value list so it displays the text instead of the number,
then change the field's display back to a text box so you
can see what's really there.