Display Option Group label name versus value

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

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!
 
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!
Click to expand...

In the report, add an unbound text control.
Set it's Control Source to:
=Choose([OptionGroupName],"Freshman","Sophomore","Junior","Senior")
 
pht1991 said:
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.
Click to expand...

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.
 
Back
Top