select text from an option group

[Guest]

Hi group,

How can i select in a report, the text from an option group?
I´ve tried the line below, but it didn´t work.
=[Forms]![F Products]![From].Value

Thanks for any help,
Rodolfo Fontes

 

[Jeff Boyce]

Rodolfo

I'm not sure I understand. Usually, option groups exist in forms, not
reports. Are you saying you have an option group in a report? If so,
referring to the Forms!... won't see it!

Have you tried referring to Reports!....?

 

[Jeff Boyce]

Rodolfo

It is the Caption property of the label of the chosen option that you wish,
correct? The option group knows only the value assigned to the option
chosen ... and you can use any value you wish for the options.

One approach might be to create a procedure in the OnFormat event of the
Details section. In this procedure you could use a Select Case statement to
recreate the text string you wished to display. The problem with this
approach is that it requires keeping the text on the form and the text
derived in the report maintained in synchrony.