display value of button?

[bb67dart]

I have a data entry form with lots of option groups with radio buttons
inside them. It would be great to be able to show the value of those
radio buttons, along with the labels, to act as a "data key" to help
interpret the data. Is this possible?

 

[KARL DEWEY]

Where do you want to show them?
I just use them as criteria in a query like this ---
[Forms]![YourFormName]![Frame4]
or what ever frame number that was assigned when the option group was created.

 

[bb67dart]

Hi Karl - I should have been more clear. I would like to show them on
the form itself -- so that when I'm looking at a table with 1s and 2s
and 3s, I can look at the form and see that 1 corresponds to "Not
often" and 3 corresponds to "Very often" for any given field (option
group in this case)..

Where do you want to show them?
I just use them as criteria in a query like this ---
[Forms]![YourFormName]![Frame4]
or what ever frame number that was assigned when the option group was created.

--
KARL DEWEY
Build a little - Test a little

I have a data entry form with lots of option groups with radio buttons
inside them. It would be great to be able to show the value of those
radio buttons, along with the labels, to act as a "data key" to help
interpret the data. Is this possible?

 

[KARL DEWEY]

You can build a nested IIF in your query like this ---
Frequency: IIF([Forms]![YourFormName]![Frame4] = 1, "Never",
IIF([Forms]![YourFormName]![Frame4] = 2,"Not often", "Very often")

Or you can build a table and left join your data table field to it. The
table would look like this ---
Frequency ---
Option Frequency
1 Never
2 Not often
3 Very often



--
KARL DEWEY
Build a little - Test a little

Hi Karl - I should have been more clear. I would like to show them on
the form itself -- so that when I'm looking at a table with 1s and 2s
and 3s, I can look at the form and see that 1 corresponds to "Not
often" and 3 corresponds to "Very often" for any given field (option
group in this case)..

Where do you want to show them?
I just use them as criteria in a query like this ---
[Forms]![YourFormName]![Frame4]
or what ever frame number that was assigned when the option group was created.

--
KARL DEWEY
Build a little - Test a little

I have a data entry form with lots of option groups with radio buttons
inside them. It would be great to be able to show the value of those
radio buttons, along with the labels, to act as a "data key" to help
interpret the data. Is this possible?

 

[bb67dart]

Again I have failed in my explanation, but thanks for the input so
far. I am trying to view/print-out the form, which will show the
values assigned to the radio buttons within the option group.

E.g. the form view typically shows

1. How often do you sleep 8 hours a night?
[] Not often
[] Often
[] Very often

the [] are radio buttons, all in an option group linked to variable
'sleep' in a table. If I look at the properties of the radio buttons,
I can see that the radio button next to "Not often" has a value of 1.
What I am after here is a way to display the value assigned to every
radio button in each option group. For example, ideally it would put
the number near/over the top of the radio button (or in place of it, I
don't care what happens to the radio buttons at this point, I just
want to see the value so I can interpret the values in the table):
e.g.,

1. How often do you sleep 8 hours a night?
1 Not often
2 Often
3 Very often


Thanks again for any suggestions.
Dave

You can build a nested IIF in your query like this ---
Frequency: IIF([Forms]![YourFormName]![Frame4] = 1, "Never",
IIF([Forms]![YourFormName]![Frame4] = 2,"Not often", "Very often")

Or you can build a table and left join your data table field to it. The
table would look like this ---
Frequency ---
Option Frequency
1 Never
2 Not often
3 Very often

--
KARL DEWEY
Build a little - Test a little

Hi Karl - I should have been more clear. I would like to show them on
the form itself -- so that when I'm looking at a table with 1s and 2s
and 3s, I can look at the form and see that 1 corresponds to "Not
often" and 3 corresponds to "Very often" for any given field (option
group in this case)..

Where do you want to show them?
I just use them as criteria in a query like this ---
[Forms]![YourFormName]![Frame4]
or what ever frame number that was assigned when the option group was created.
--
KARL DEWEY
Build a little - Test a little
:
I have a data entry form with lots of option groups with radio buttons
inside them. It would be great to be able to show the value of those
radio buttons, along with the labels, to act as a "data key" to help
interpret the data. Is this possible?

 

[KARL DEWEY]

They are not there for human consumption but for machine alone. But if you
insist then you can use a label over the button.

I still think the nested IIF statement is the way for humans.
--
KARL DEWEY
Build a little - Test a little

Again I have failed in my explanation, but thanks for the input so
far. I am trying to view/print-out the form, which will show the
values assigned to the radio buttons within the option group.

E.g. the form view typically shows

1. How often do you sleep 8 hours a night?
[] Not often
[] Often
[] Very often

the [] are radio buttons, all in an option group linked to variable
'sleep' in a table. If I look at the properties of the radio buttons,
I can see that the radio button next to "Not often" has a value of 1.
What I am after here is a way to display the value assigned to every
radio button in each option group. For example, ideally it would put
the number near/over the top of the radio button (or in place of it, I
don't care what happens to the radio buttons at this point, I just
want to see the value so I can interpret the values in the table):
e.g.,

1. How often do you sleep 8 hours a night?
1 Not often
2 Often
3 Very often


Thanks again for any suggestions.
Dave

You can build a nested IIF in your query like this ---
Frequency: IIF([Forms]![YourFormName]![Frame4] = 1, "Never",
IIF([Forms]![YourFormName]![Frame4] = 2,"Not often", "Very often")

Or you can build a table and left join your data table field to it. The
table would look like this ---
Frequency ---
Option Frequency
1 Never
2 Not often
3 Very often

--
KARL DEWEY
Build a little - Test a little

Hi Karl - I should have been more clear. I would like to show them on
the form itself -- so that when I'm looking at a table with 1s and 2s
and 3s, I can look at the form and see that 1 corresponds to "Not
often" and 3 corresponds to "Very often" for any given field (option
group in this case)..

On Sep 20, 2:56 pm, KARL DEWEY <[email protected]>
wrote:
Where do you want to show them?
I just use them as criteria in a query like this ---
[Forms]![YourFormName]![Frame4]
or what ever frame number that was assigned when the option group was created.

:
I have a data entry form with lots of option groups with radio buttons
inside them. It would be great to be able to show the value of those
radio buttons, along with the labels, to act as a "data key" to help
interpret the data. Is this possible?