Using an event to change color of text.

[michaeljohnh]

Im looking to give the users of a form some visual cues indicating in what order combo boxes need to be clicked. Even though the order is a straight forward top to bottom sequence, I believe in going the extra mile.

So say the object is a label and is named lblCategory. Is there a VB command that will change the label's text color? Then Its just a matter of me putting that command into the proper event in the corresponding combo boxes, which I can handle.

Thanks in advance.

[TheShabz]

check this link out.

http://www.access-programmers.co.uk/...ad.php?t=34499

i believe you would use Control.Label instead of just control and you would set it in the afterUpdate property of the combobox prior to the one you want to change the color of. Meaning, the code to change the color of combo2 is in the afterUpdate of Combo1.

Hope this helps.

[RuralGuy]

FWIW, the label for each control has its own name usually starting with lbl. I believe if the label is attached to a control. it can also be referenced through that controls' collection.

[ajetrumpet]

Im looking to give the users of a form some visual cues indicating in what order combo boxes need to be clicked. Even though the order is a straight forward top to bottom sequence, I believe in going the extra mile.

So say the object is a label and is named lblCategory. Is there a VB command that will change the label's text color? Then Its just a matter of me putting that command into the proper event in the corresponding combo boxes, which I can handle.

Thanks in advance.

If you're looking to be in good graces with management, you might want to consider some good explanation to the users during a meeting instead of complex automation. The people I've worked with have always appreciated good explanation of "why's" a lot more than automation as a substitute for their ignorance. People seem to love to learn technology (if it's not too complicated). And of course, Access is on the low end of complication if you compare it to others out there.