Combo Box Colour Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a Combo Box that has 2 Options from Row Source (Active,Finished), How
can I get the Font to change from say Black to Red when (Finished) is
selected!


Thanks in advance.........Bob Vance
 
How can I get the Font to change from
say Black to Red when (Finished) is
selected!
Click to expand...

Open the Form in Design View, right-click the Combo, and choose Conditional
Formatting. It seems intuitive to me.

Larry Linson
Microsoft Access MVP
 
Thanx Guys, Im not that stupid just forgetful :)

Larry Linson said:
Open the Form in Design View, right-click the Combo, and choose
Conditional Formatting. It seems intuitive to me.

Larry Linson
Microsoft Access MVP
Click to expand...
 
Is it possible to do the same with a text box, so if cbStatus (Combo Box)
shows Finished the text will change in a Text Box.....Thanx Bob
 
I tried from the text box did not know how to locate the combo box from
there? Thanx...Bob
Click to expand...

Set the Condition1 for the Text control to:
Expression Is
Write:
[cbStatus] = "Finished"
in the dialog box.

Select your colors and save the changes.
 
BRILLIANT Fred Thanks very much!!

fredg said:
I tried from the text box did not know how to locate the combo box from
there? Thanx...Bob
Click to expand...

Set the Condition1 for the Text control to:
Expression Is
Write:
[cbStatus] = "Finished"
in the dialog box.

Select your colors and save the changes.
Click to expand...
 
Back
Top