Option button labels

[lars]

I can't find where to do this and its going to drive me nuts!!
I made an Option Group. I have labels assigned to the numerical entries in
the group.
Now I want to make a report. I can get the report to group by the Options,
but I want to make labels with the names of the Options instead of the
numbers. Where do I go to tell the report-

If the [Program Type]= 1 display text "XXXXX"
else if [Program Type]= 2 display text "YYYY"
else if [Program Type]= 3 display text "ZZZZZ

Your assistance is greatly appreicated!! (Access 2000, Windows 2000).

LAR-S

 

[lars]

Found a solution that works pretty well-
IIf([Program Type]=1, "XXXXX")

I made three unbound text boxes with this formula for each option and then
overlayed them in the report. Works great!!

If there's something better, let me know.

 

[Douglas J. Steele]

You might find the Choose function more appropriate:

=Choose([Program Type], "XXXXX", "YYYYY", "ZZZZZ")

--
Doug Steele, Microsoft Access MVP

Found a solution that works pretty well-
IIf([Program Type]=1, "XXXXX")

I made three unbound text boxes with this formula for each option and then
overlayed them in the report. Works great!!

If there's something better, let me know.

I can't find where to do this and its going to drive me nuts!!
I made an Option Group. I have labels assigned to the numerical entries in
the group.
Now I want to make a report. I can get the report to group by the Options,
but I want to make labels with the names of the Options instead of the
numbers. Where do I go to tell the report-

If the [Program Type]= 1 display text "XXXXX"
else if [Program Type]= 2 display text "YYYY"
else if [Program Type]= 3 display text "ZZZZZ

Your assistance is greatly appreicated!! (Access 2000, Windows 2000).

LAR-S

 

[Terry]

Lars,

In the report section's "On Format" event.

If it's in a group header then in the group header's on
format event. If it's in the detail section then in the
detail's on format event.

HTH,

Terry