Convert value of option button

  • Thread starter Thread starter Sandra Grawunder
  • Start date Start date
S

Sandra Grawunder

I have an option button group for PmtType on a form. How
can I convert the numeric value of the selection to text
for a group header in a report? For instance:
1 = Cash
2 = Check
3 = Credit Card

Thanks,

Sandra G
 
I have an option button group for PmtType on a form. How
can I convert the numeric value of the selection to text
for a group header in a report? For instance:
1 = Cash
2 = Check
3 = Credit Card

Thanks,

Sandra G
Click to expand...

If those are the only choices, then add an unbound control to the
group header.
Set it's control source to:
=Choose([OptionGroupName],"Cash","Check","Credit Card")

You could also use IIf().
=IIf([OptonGroupName]=1,"Cash",IIf([OptionGroupName]=2,"Check","Credit
Card"))
 
Back
Top