Change option group inherent values

[antoniosilv]

Hello,

I have a form with an option group in order to classify some parameters. I have created a simple debug example in order to understand all the information https://www.dropbox.com/s/sh162n5sbm...oup.accdb?dl=0

The option group has three options (Excellent, good or spoilt). Access creates inherent values (1, 2 and 3) to save the selection information in the table as it can be seen in the following image:
https://www.dropbox.com/s/t2nl9uib6p...Group.png?dl=0
Note that the values cannot be changed to strings

When creating the excel, the following results are obtained:
https://www.dropbox.com/s/3s502hffht...lInfo.png?dl=0

Well, for the users, the information (1, 2 or 3) is not enough because they do not know what is the correspondence.

I have thought in applying a replace all VBA line code to substitute the values, but this is not a good approach.

Could you please help me with some ideas?

Thank you!!!!

[Seth Schrock]

Probably the easiest would be to create a table with two fields: an ID field and a description field that allows you to link the 1,2, and 3 to the proper description. You can then create a query that joins the table that you are currently working on to this new table using the ID field and the field that your option group is linked to as the join fields. Then display the description field instead of the number field. You can then export this query to Excel.

[antoniosilv]

Hello Seth Schrock,

I will implement your solution in order to solve my problem.
Thank you!

[antoniosilv]

Hello again Seth Schrock,

I think your solution only works if only one field is being converted. Am I right or am I missing something?
In my case, I have a list of 12 fields associated to the option group
Thank you

[Seth Schrock]

Are you saying that you have 12 different fields, each of which can have the values of Excellent, good or spoilt (1,2 or 3)? If so, then you would just add the new table 12 times to the query editor (it will give all but the first one an alias) joining each one to a different one of the 12 fields and then you would once again only display the description fields, but in this case the description field from each of the 12 fields. I would recommend providing an alias for each of the description fields to make the export easier to understand.

If that isn't what you are describing, then I'm lost.

[antoniosilv]

@Seth Schrock

It is exactly as you stated, 12 different fields each of which can have the values of Excellent, good or spoilt (1,2 or 3).
With the 12 new tables added to the query, I was able to finally finish this task.
Thank you!!!!