Conditional formatting based on the value of another field

  • Thread starter Thread starter RSunday
  • Start date Start date
R

RSunday

I have a report listing records. I would like the text part of a record to
change font color based on the value in another field of the same record.

How do I do that?
 
What do you mean by the Text part? Are you referring to another textbox
control or are you referring to a label?

You can use conditional formatting on textbox controls, but not on label controls.

Guessing that you mean a text box control, then click on it, select
conditional formatting and use the Expression is option

Set your expression to something like

[AnotherField] = "My value"

Then set up you font color change.

If you need to do this with a label, you can convert the label to a textbox
control and set its control source to something like
="This is my label"

Or you can use VBA to change the font color of the label in the format event
of the section that contains the label

IF [AnotherField] = "My value" Then
ME.SomeLabel.ForeColor = vbRed
ELSE
ME.SomeLabel.ForeColor = vbBlack
END IF


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
You guessed right! And solved my problem. Thanks!

John Spencer said:
What do you mean by the Text part? Are you referring to another textbox
control or are you referring to a label?

You can use conditional formatting on textbox controls, but not on label controls.

Guessing that you mean a text box control, then click on it, select
conditional formatting and use the Expression is option

Set your expression to something like

[AnotherField] = "My value"

Then set up you font color change.

If you need to do this with a label, you can convert the label to a textbox
control and set its control source to something like
="This is my label"

Or you can use VBA to change the font color of the label in the format event
of the section that contains the label

IF [AnotherField] = "My value" Then
ME.SomeLabel.ForeColor = vbRed
ELSE
ME.SomeLabel.ForeColor = vbBlack
END IF


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I have a report listing records. I would like the text part of a record to
change font color based on the value in another field of the same record.

How do I do that?
Click to expand...
Click to expand...
 
John Spencer said:
What do you mean by the Text part? Are you referring to another textbox
control or are you referring to a label?

You can use conditional formatting on textbox controls, but not on label controls.

Guessing that you mean a text box control, then click on it, select
conditional formatting and use the Expression is option

Set your expression to something like

[AnotherField] = "My value"

Then set up you font color change.

If you need to do this with a label, you can convert the label to a textbox
control and set its control source to something like
="This is my label"

Or you can use VBA to change the font color of the label in the format event
of the section that contains the label

IF [AnotherField] = "My value" Then
ME.SomeLabel.ForeColor = vbRed
ELSE
ME.SomeLabel.ForeColor = vbBlack
END IF


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
Thank you John! Really Easy!
 
Back
Top