Rows in report

[petercummins]

Changing the text colour on reports

I have a report in Accessrun against a query.

In the report I want each line that starts with 'F' to be returned as coloured RED and I want all others return as GREY.

Is there a way of doing this through Access functions or do I have to use some VB code.

Any help would be appreciated.

 

[petercummins]

I have a report in Access run against a query.

I am wanting to return all the rows that start with 'F' coloured RED.

All the others just to stay as they are.

'F' is an ID and every row starts with a single letter.

Do you have to do this in a VB code or is there a function in Access that does it for you?

Any help would be appreciated. Thanks.

 

[Pat Hartman]

In case you're wondering what happened, I merged your two threads because they were asking the same question with a slight variation.

Use conditional formatting as long as you don't have any more than 4 choices.

 

[petercummins]

I posted two by mistake sorry. Thanks for your help.