Change text colour in Report based on condition

[Stiruchi]

Can anyone tell me how I can change text colour in [FIELD1] in report
if [FIELD2], a tick box is true.

Thanks in advance
ST

 

[tina]

check out conditional formatting under the Format menu in report Design
view.

hth

 

[Stiruchi]

check out conditional formatting under the Format menu in report Design
view.

hth

Can anyone tell me how I can change text colour in [FIELD1] in report
if [FIELD2], a tick box is true.

Thanks in advance
ST

Thanks for the tip. But not sure how this works when I have 2 fields.
If the tick box is enabled in one field I want the text in another
field to change colour.

 

[tina]

set the formatting on FIELD1. in the Conditional Formatting dialog box,
choose Expression Is (instead of the default Field Value Is). in the long
field at the right, add the expression

[FIELD2] = True

hth

check out conditional formatting under the Format menu in report Design
view.

hth

Can anyone tell me how I can change text colour in [FIELD1] in report
if [FIELD2], a tick box is true.

Thanks in advance
ST

Thanks for the tip. But not sure how this works when I have 2 fields.
If the tick box is enabled in one field I want the text in another
field to change colour.