Option Group To Return Text Instead of a Value

[justair07]

Hello,

Does anyone know if it is possible for an option group to return a text instead of a value? I really like the way the option group looks but don't want my data to be populated with a value. I need it to populate with text instead. I know this is achievable with other tools, but really don't want to use anything other than an option group.

Thank you,



-justair

[June7]

The Option Group control would have to be unbound then use VBA code to convert the value and save text and code to convert back for proper display of the correct item in the Group. This will not work in continuous form.

[justair07]

I guess it's easier to just it as a value.

[June7]

Yes.

Use expression in report to translate the number to a text representation.