Possible to change text color on conditions

[avayaman]

Hi I was wondering if its possible to change the color of text in a field showing on a form depending on the state of another field for the same entry in the database?

This is a membership database and there is a status field at play (Active, expired, etc)

One form is a roledex of names and the one field in there (let's call it last name), I want to have the text change color, say red if the individual is expired according to the status field. I looked through the properties box but can't see anywhere in there to do it.

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[avayaman]

Don't mind me, on a search I just discovered Access has conditional formatting

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[missinglinq]

In Conditional Formatting, to base formatting on one field based on another field, you'd use

Expression Is

in the first box, then

[StatusFieldName] = "expired"

in the next box, then choose your formatting using the icons.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!