option group

[kavi]

Hi all,
I have placed an option group with four options which saves the option values in a field in a table. The option values are saved as 1,2,3,and 4 in the table. How can I display the details instead of the option values in a report or in a form which displays a list.

Thanks

 

[jjturner]

Hello and Welcome!

Depending on your circumstances, you can create/keep a "Lookup" table - the values 1,2,3 & 4 will be the Autonumber field. Your names pertaining to each option will be the myOptionName field. Then you link this table with your main table in the query.

Apart from a Lookup table, you could use the Choose function as a calculated field in your query:

Choose([myOptionValueField], "myOptionName1", "myOptionName2", etc. )

Hope this helps.

Regards,
John