Option Group radio button

  • Thread starter Thread starter Curt
  • Start date Start date
C

Curt

I have a subform with an option group that has 3 option
buttons. My question is how can I store the label in my
table it is related to rather than the number? I need
this label to be used in query for a listbox.

thanks for any assistance.
 
I have a subform with an option group that has 3 option
buttons. My question is how can I store the label in my
table it is related to rather than the number? I need
this label to be used in query for a listbox.

thanks for any assistance.
Click to expand...

An OptionGroup's value is a number.
You can't store a Text value in a number datatype field.
It should not cause any difficulty.
To display the OptionGroup's value as text in a report, simply use an
unbound text control:
=IIf([OptionGroupField] = 1, "TextA",IIf([OptionGroupName] = 2,
"TextB","TextC"))

If the group had many more options you could use Switch(), Choose(),
or Select Case to convert the number value to text.
 
Back
Top