Replace Numbers from Form Option Group with Name

[b2beck]

I have a field generated from an options group on a form which contains numbers and nulls (as, I understand, all fields generated from options groups must contain). I want to group records on a report by these numbers for reviewers but the would like something more descriptive than "1" or "2" for the headings.

I assume that the best method to do this is to add a text box "controlled" by the field or the lookup table linked to it. But I can't find out how to do it in the books I have.

Thanks for any help.

 

[Rick39]

Take a look at the Switch function

 

[Celeste025]

I do this on a report using an IIf statment. Im using it for a Yes/No control box, but I assume it could be modified to fit your needs.

=IIf(([Review Back Orders]='0'),"","Review Back Orders, &quot & IIf(([Analyze Fill Rate]='0'),"","Analyze Fill Rate, &quot & IIf(([Order Written]='0'),"","Order Written, &quot & IIf(([Presented Business Plan]='0'),"","Presented Business Plan, &quot & IIf(([Other]='0'),"","Other&quot

This says if the field [Review Back Orders] is set to No, dont print anything, otherwise print "Review Back Orders", and if the field [Analyze Fill Rate] is set to No, dont print anything.....

I'm not sure if you can use it for more than two options, like if [field]=1 print "decription1" or if [field]=2 print "description2" etc...