Conditional formatting question

[Guest]

Hi, Is it possible to change the font color of a text box based on the
condition of another text box on the same form. I have a field "FirstName"
and another field "CallStatus". If i type call made in "CallStatus" the text
in "FirstName" should change to some color and if I type a different
expression in "CallStatus" then the font in "FirstName" should change to a
different color. Any help
many thanks
AJ

 

[tina]

open your form in design view. click once on the control FirstName to select
it. on the menu bar, click Format | Conditional Formatting. in the dialog
box, change Field Value Is to Expression Is. in the next field, enter your
expression, for example:

CallStatus = "something"

then set the font color you want. to add another condition (CallStatus =
"something else"), click the Add button.

hth

 

[Guest]

Hi, I am able to change the color of the font but the it changes the font
color of all the names. I want to change the color of each record.

AJ

 

[tina]

if you're using *Conditional* Formatting, it should not. i just tested it
myself, in an Access 2000 database running in Access 2003: i set two
different conditions, each of which applied to only a few values in a table
with numerous records. i opened the form in Continuous Forms view and in
Datasheet view. in both views, the conditional formatting was immediately
and correctly applied to only the appropriate control in only the
appropriate records.

other than suggesting that you re-read my previous post and then
double-check your setup, i'm afraid i don't have anything else to offer,
sorry.