Software

Ask something
Question Locked

Make an Access 2003 form check box stand out when selected

0 helpful
7 replies

by tlg1025

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a user that has multiple check boxes on an Access 2003 form. When tabbing through the fields it is sometimes hard to tell which check box field is selected. She would like to have a way for the check box to stand out when it is selected.

7 replies

by route81

You might add a marker in front or behind the checkbox (an arrow for example) or change the color of the corresponding label. Do this with the 'on got focus'-event of the checkbox and invisible with the 'on lost focus'-event.

by rw2000

I usually set each checkbox label's background color to be noticeable, then make it transparent. In the form's module:
Private Sub Check1_GotFocus()
lblCheck1.BackStyle = 1 'visible
End Sub
Private Sub Check1_LostFocus()
lblCheck1.BackStyle = 0 'transparent
End Sub

by tlg1025

I am learning all sorts of new things today! I will give this one a try and see if it works too. Then I can give my user multiple options.

by tlg1025

Thank you! Yesterday I had been trying to use the focus events by changing the borders (I tried both the checkbox and label borders) and that was just not working. I had not considered changing the font. Talk about not thinking outside the box...literally! ;)
Changing the font worked like a charm in my testing so now I need to contact my user to make sure that is what she is looking for!

by sgt_shultz

a conditional formatting 'wizard' is built into my version of Access (2003)
in your form, in design view, select the control (checkbox) then pick Format/Conditional Formatting

by fleztek

this very day I have been trying to find a way to do EXACTLY this - wouold you believe it ? Gave up and decided to trawl my eMail, saw this Post listed on a Daily Tech Republic Post I receive.

Amazing - even works in Wordpad, where I was attempting to build a small check list.

TechRepublic keeps on ROCKING !

This discussion is closed to new replies.