troubleshooting Question

Option Box - change color if Yes option selected

Avatar of pdvsa
pdvsaFlag for United States of America asked on
Microsoft Access
10 Comments3 Solutions459 ViewsLast Modified:

I have an option box on the form.
Yes = -1  No = 0

I want to somehow highlight the label "Yes" or color the Yes option button if Yes is selected.  I am trying to make it easier to see if the Yes button is selected.

I thought I could do something like the below but I dont think this is the correct approach.  

let me know...thanks

Private Sub Form_Current()

If Me.Option211 = -1 Then
        Me.Option211.BorderColor = vbRed
        Me.Option211.BorderColor = vbBlack
    End If
Join our community to see this answer!
Unlock 3 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros