Change the color of the label on a Y/N form element basedupon value

[seo-highrankings.com]

Hi All,

Can I change the label color (text) of a Y/N control based upon its value?
I need to alert the user if the value is checked.

Is there a better way to do it?

Thanks!

--

James Taylor

http://www.aicompany.com - Search Engine Optimization Services
http://www.seo-highrankings.com - Free SEO Tools!

 

[tina]

in the form's OnCurrent event, and the checkbox's AfterUpdate event, call
the following sub, as

Private Sub ChangeColor()

Wth Me
If .CheckboxName Then
.CheckboxLabelName.BackColor = 255
Else
.CheckboxLabelName.BackColor = 138
End If
End With

End Sub

substitute the correct control names and the correct color numbers, of
course. fyi, this will not give you the results you want to see if the form
is a "continuous" form.

hth

 

[seo-highrankings.com]

Thanks Tina!

No, it is not a continuous form.

Thanks again!

--

James Taylor

http://www.aicompany.com - Search Engine Optimization Services
http://www.seo-highrankings.com - Free SEO Tools!