Displaying Option Group on Reports

[Guest]

Hello,

I used an option group on my form to select one of three choices for each
record. When creating a report to display that information, it only displays
"1", "2" or "3".

Is there a setting that will allow the report to display the descriptive
text that is associated with the numeric value on the form? If not, does
anyone have any suggestions or work arounds? Please advise.

Thanks,
Jim

 

[Guest]

Hi Jim

Use the option selection to set the value of a field and insert this into
the report not the option group itself.

 

[fredg]

Hello,

I used an option group on my form to select one of three choices for each
record. When creating a report to display that information, it only displays
"1", "2" or "3".

Is there a setting that will allow the report to display the descriptive
text that is associated with the numeric value on the form? If not, does
anyone have any suggestions or work arounds? Please advise.

Thanks,
Jim

Use an unbound text control.
Set it's control source to:
=IIf([OptionGroupName]=1,"DisplayText1",IIf([OptionGroupName] =
2,"DisplayText2","Displayext3"))

Or you could use the Choose function:
=Choose([OptionGroupName],"DisplayText1",DisplayText2","Displayext3")

 

[Guest]

Hi Jim

Use

Private Sub FramName_AfterUpdate()
Select Case Me!FrameName
Case 1
Me.Somefield = Something
Case 2
Me.Somefield = SomethingElse
Case 3
Me.Somefield = SomethingOther
End Select
End Sub

To give the field a value. Fredg's answer will work fine for a one record
report (like an address lable, recipte, etc) but for most reports (that have
more details concerning multiple records) use the frame to set the value of a
field.

--
Wayne
Manchester, England.

Hello,

I used an option group on my form to select one of three choices for each
record. When creating a report to display that information, it only displays
"1", "2" or "3".

Is there a setting that will allow the report to display the descriptive
text that is associated with the numeric value on the form? If not, does
anyone have any suggestions or work arounds? Please advise.

Thanks,
Jim

Use an unbound text control.
Set it's control source to:
=IIf([OptionGroupName]=1,"DisplayText1",IIf([OptionGroupName] =
2,"DisplayText2","Displayext3"))

Or you could use the Choose function:
=Choose([OptionGroupName],"DisplayText1",DisplayText2","Displayext3")

 

[Guest]

Hi FredG,

Thank you very much! I used your second suggestion and it worked perfectly.
Wayne, thank you for your suggestions, as well. I will save your response
in case I need to run a report that displays data from multiple records.

Sincerely,
Jim

Hello,

I used an option group on my form to select one of three choices for each
record. When creating a report to display that information, it only displays
"1", "2" or "3".

Is there a setting that will allow the report to display the descriptive
text that is associated with the numeric value on the form? If not, does
anyone have any suggestions or work arounds? Please advise.

Thanks,
Jim

Use an unbound text control.
Set it's control source to:
=IIf([OptionGroupName]=1,"DisplayText1",IIf([OptionGroupName] =
2,"DisplayText2","Displayext3"))

Or you could use the Choose function:
=Choose([OptionGroupName],"DisplayText1",DisplayText2","Displayext3")