Option button labels

  • Thread starter Thread starter lars
  • Start date Start date
L

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
 
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.
 
You might find the Choose function more appropriate:

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

--
Doug Steele, Microsoft Access MVP



lars said:
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.

lars said:
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
Click to expand...
Click to expand...
 
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
 
Back
Top