option groups

[noe1818 via AccessMonster.com]

I want to put an option group on a form and have the results be recorded in
my table as text. What should I do in order to convert the number values to
associated text options? I tried using a field list table that held all my
options, but I can't figure out how to get the display to show the text
options. If your answer includes using a query, explain how to set it up, as
I'm not too good with queries.

 

[Douglas J. Steele]

If you've got a table that translates the numeric value to a text
description, why do you care? Store the number, and join the two tables in a
query.

 

[noe1818 via AccessMonster.com]

How do you create a table that translates numbers to texts?

 

[Douglas J. Steele]

NumericValue TextValue
1 Something
2 Something else
3 Yet something else

 

[noe1818 via AccessMonster.com]

I don't understand what this means? Are these two tables, or stuff in one
table? How do you get the text values to appear in the table. I'm really lost.

 

[Douglas J. Steele]

That's one table with two fields. One field contains the numeric value, the
other field contains the text. You key both pieces of information into the
table.

Your original question was "I want to put an option group on a form and have
the results be recorded in my table as text. What should I do in order to
convert the number values to associated text options?"

Once you're created the table below that indicates what the text is
corresponding to each option group value, you'd store the numeric value in
your existing table, rather than text. You'd then create a query that joins
your existing table to the table below on the NumericValue so that your
query can display the TextValue for each row in the existing table. You'd
then use that query anywhere you would otherwise have used the table.

 

[noe1818 via AccessMonster.com]

I FINALLY UNDERSTAND!!!! It took me awile, but I figured it out, thank you so
much. I have read your suggestions in many other threads, and I appreciate
the fact you want to help people like me.
-Noe

That's one table with two fields. One field contains the numeric value, the
other field contains the text. You key both pieces of information into the
table.

Your original question was "I want to put an option group on a form and have
the results be recorded in my table as text. What should I do in order to
convert the number values to associated text options?"

Once you're created the table below that indicates what the text is
corresponding to each option group value, you'd store the numeric value in
your existing table, rather than text. You'd then create a query that joins
your existing table to the table below on the NumericValue so that your
query can display the TextValue for each row in the existing table. You'd
then use that query anywhere you would otherwise have used the table.

I don't understand what this means? Are these two tables, or stuff in one
table? How do you get the text values to appear in the table. I'm really

[quoted text clipped - 6 lines]

 

[New_Access]

I'm sorry Mr.Douglas,
I want to use radio button option group.
Then, I use wizard to create the option group,
but if I define which field will store the value of
option group,the group then become disable in
my form.What's wrong with that?.
Thank's before

That's one table with two fields. One field contains the numeric value, the
other field contains the text. You key both pieces of information into the
table.

Your original question was "I want to put an option group on a form and have
the results be recorded in my table as text. What should I do in order to
convert the number values to associated text options?"

Once you're created the table below that indicates what the text is
corresponding to each option group value, you'd store the numeric value in
your existing table, rather than text. You'd then create a query that joins
your existing table to the table below on the NumericValue so that your
query can display the TextValue for each row in the existing table. You'd
then use that query anywhere you would otherwise have used the table.