Combo Box Colour Question

[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

 

[Arvin Meyer [MVP]]

Use Conditional Formatting. In form Design View, select the combo box. From
the Format menu, select Conditional Formatting, and set the format when the
Value is equal to "Finished"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

How can I get the Font to change from
say Black to Red when (Finished) is
selected!

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

Larry Linson
Microsoft Access MVP

 

[Bob]

Thanx Guys, Im not that stupid just forgetful

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

Larry Linson
Microsoft Access MVP

 

[Bob]

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

 

[Arvin Meyer [MVP]]

Yes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Bob]

I tried from the text box did not know how to locate the combo box from
there? Thanx...Bob

 

[fredg]

I tried from the text box did not know how to locate the combo box from
there? Thanx...Bob

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

Select your colors and save the changes.

 

[Bob]

BRILLIANT Fred Thanks very much!!

I tried from the text box did not know how to locate the combo box from
there? Thanx...Bob

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

Select your colors and save the changes.