Change Associated Label on GotFocus 2

[jmstarbuck]

Hi all,

In my forms I generally change the backcolor of a control when it gets focus. However, that doesn't work for checkboxes so I would like to make the label associated with the control that just got focus bold.

I can't find a way to refer to the associated label. Any ideas?

Best,
Janice

 

[PHV]

Me![name of checkbox control].Controls(0).BackColor

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jmstarbuck]

Thanks for your speedy response!

This is what I tried:

Private Sub DisabilityHO1_GotFocus()
    Me![DisabilityHO1].Controls(0).BackColor = cYellow
End Sub

I get error 2467 "The expression you entered refers to an object that is closed or doesn't exist."

Thoughts?

 

[dhookom]

The code worked for me assuming:
1) cYellow is a declared memory variable
2) The label background is not transparent

Duane
Hook'D on Access
MS Access MVP

 

[jmstarbuck]

Yep, my background was transparent.

Thanks so much!