Conditional formatting - one field used to determine anothers appearance

[alunkane]

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.

 

[Pat Hartman]

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.

 

[smercer]

Are you trying to do this in datasheet view or form view?

 

[alunkane]

I'm trying to do it in form view.

 

[smercer]

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

 

[alunkane]

many thanks....