different colors when there is filter (1 Viewer)

[ilanray]

Hello
I have a table and one of the fields is "status". In the report I would like to paint all backgroud row in green when the status is "done" .
if it is not possible I would like to paint all fields in the same row with green
Can someone help me with that?

regards

 

[bob fitz]

Take a look at Conditional Formatting of Controls(textboxes etc)
You will be able to set the backround colour of controls dependent on the value of "Status"

 

[MajP]

if it is not possible I would like to paint all fields in the same row with green

You can apply the same conditional formatting to all textboxes or you can put a single textbox behind all your controls and paint that one which will make it look like the row is colored.