Option Group/ Radio Buttons/ MS Access?

We have created a choice group (just Shape 53) in addition to inside it there are actually 3 radio buttons using the names Imperfect, Passed, in addition to Failed.Determined by which mouse they press it’s going to change this text from a text box the user can’t change (except by simply pushing your radio buttons).Incomplete can change the text for you to incomplete and ensure it is white.Passed can change the text for you to Passed and ensure it is green.Failed can change the text for you to Failed and ensure it is red.

The issue is this is this goal plus I have no clue how to accomplish it.if any individual could document some effective code to me (or at the very least get me on the right track) it might be much prized.

Let’s state you assigned Pass, Incomplete, and Fail the prices 1, A COUPLE OF, 3 once you created the choice group.Your copy box is named txtGrade and also it’s on the same form as the option number.

Private Sub Frame53_AfterUpdate()
Choose Case Frame53.Value
Circumstance 1
txtGrade.Value = “Pass”
txtGrade.BackColor =
Circumstance 2
txtGrade.Value = “Incomplete”
txtGrade.BackColor =
Circumstance 3
txtGrade.Value = “Fail”
txtGrade.BackColor =
Conclude Select

Conclude Sub

I haven’t much filled in the color numbers however you can figure that released.

Use the on simply click event for any frame.Utilize a select statement to handle all a few variations.

Nonetheless, I wouldn’t use a textbox.If the user are unable to edit it and is particularly only regarding display, you should use a label.Only try a textbox if you want to give a computer owner the ability to edit the contents belonging to the textbox.