Conditional Formatting of a label

[pbparady]

In an Access 2010 form, I want to trigger a change of the text color of a label, when it's corresponding checkbox is selected (Simply checking the box is not enough for these users)



I've found a reference to doing this by changing the label to a text box, and setting it's control source to to a text string. I've tried setting the control source ="Label Text" but this is not working. Any help is greatly appreciated.

[RayMilhon]

No need to change it to a textbox.

in the click event of the checkbox use the following

If check1 then label1.forecolor = vbRed Else label1.forecolor = vbblack

Where check1 is the name of your checkbox
label1 is the name of the associated label