Conditional formatting - one field used to determine anothers appearance

alunkane

Registered User.
Local time
Today, 11:42
Joined
Sep 2, 2004
Messages
12
I'm still stuck with this one...

Any ideas how to use conditional formatting (or someting similar to it) to change font & background color of one form field, depending on the value of another field ?

e.g.
If the value in a field called 'gender' is "Male" the name displayed in the name field on the form will be in Blue,and if the gender is "female" the name will be displayed in red.
 
The conditional formatting works with any valid expression. Since it is the name that you want the formatting to apply to, that is the field where you would select conditional formatting.
 
Are you trying to do this in datasheet view or form view?
 
alunkane said:
I'm still stuck with this one...

Any ideas how to use conditional formatting (or someting similar to it) to change font & background color of one form field, depending on the value of another field ?

e.g.
If the value in a field called 'gender' is "Male" the name displayed in the name field on the form will be in Blue,and if the gender is "female" the name will be displayed in red.
1) You have to use the Expession as shown in the attachment.

2)then in the text box next to this enter:

[gender]="Male"
then select your formating

3) then click add and repeat step 1, then in the text box next to this enter:

[gender]="Female"
then select your formating

Does this help? Please respond
 

Attachments

  • Conditional formating.gif
    Conditional formating.gif
    15.2 KB · Views: 174

Users who are viewing this thread

Back
Top Bottom