Set Border Color of Option Group using Visual Basic

V

Van W

I'm trying to set the Border Color of a Option Group containing check boxes
on a form to the color blue (16711680) when a user clicks a check box within
the Option Group control. This will enable to user to more readily identify
questions that have not been answered. I tried the following code in the
After Update - event procedure behind the option group to no avail. Option
group named Frame35. Class Module behind the form.
If IsNull([Frame35]) = False then
Me![Frame35].BorderColor = 16711680
End If
I've tried adding the event procedure to almost all of the events of the
Option Group and nothing seems to work. I just want some way the change the
border color to reflect the the option group is no longer Null or 0 and a
check box has been elected within the group.
thanks!!!
 
M

Marshall Barton

Van said:
I'm trying to set the Border Color of a Option Group containing check boxes
on a form to the color blue (16711680) when a user clicks a check box within
the Option Group control. This will enable to user to more readily identify
questions that have not been answered. I tried the following code in the
After Update - event procedure behind the option group to no avail. Option
group named Frame35. Class Module behind the form.
If IsNull([Frame35]) = False then
Me![Frame35].BorderColor = 16711680
End If
I've tried adding the event procedure to almost all of the events of the
Option Group and nothing seems to work. I just want some way the change the
border color to reflect the the option group is no longer Null or 0 and a
check box has been elected within the group.
thanks!!!

Same question. Check your earlier thread.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top