Option Group Wizard in Form Design View

[Stephanie]

Hi,

I need help for using Option Group. When I have drawn the radio box from using Option Group Wizard in Form design view, the value entered in the form view will give the values set from option group (as default 1, 2, 3 respectively) but not the desired text like label names, can I change the value to text in order to have the label names returned in table?

Thanks.

 

[Van T. Dinh]

OptionGroup always gives one of the numeric values you nominated for the
OptionButtons.

You can use the Click or AfterUpdate Event of the OptionGroup to assign the
required Text value to a (invisible) bound TextBox or a Field in the Form's
RecordSource. Assume your Options have values 1, 2, 3, ... and the
corresponding Labels are "Label1", "Label2", "Label3", ..., you can use
something like:

Me.txtHiddenTextBox = _
Me.Controls("Label" & Me.OptionGroup).Caption

--
HTH
Van T. Dinh
MVP (Access)

Hi,

I need help for using Option Group. When I have drawn the radio box from

using Option Group Wizard in Form design view, the value entered in the form
view will give the values set from option group (as default 1, 2, 3
respectively) but not the desired text like label names, can I change the
value to text in order to have the label names returned in table?