Change text colour on report dependant on combo box selection??

[tmc]

Hello,

I have a report that details peoples employee status for the day (on duty, overtime, sick etc)

This is gained from combo box selections in a switchboard.

My question is - how do i get certain selections to display in specific colours on the report?

i.e. i'd like when overtime is selected in the switchboard, for it to be shown in red on the report - but black if any other option is selected.

However, it seems in report design view that i can only select the box and change the generic colour but not for specific selections from the combo box.

I've played with the conditional formatting option but it seems that would only solve my problem for numerical selections and not text as in my situation.

Anyone that could spare the time to help, i'd be really gratefull.

many thanks.

tmc.

 

[pbaldy]

Conditional Formatting should work for text. You may need to use Expression Is and then:

[FieldName] = "test"