Color Change in report

[Mannyf50]

Hey guys, i have a report with categories that are all a different color, could be Red, Yellow, or purple, im creating a report with the invinsible column where the color will be, the point would be if the field is Red, i want to have a Box which is around the category turn red, Ive looked all over and cant find anything.... Any ideas?? btw its in access 2002

[hjozinovic]

You should use 'BackColor' property of the control for this.
First you must set 'Back style' property to 'Normal'
Then in report's 'On Open' property put a code like this

Me!YourFieldName.BackColor = 255

This will turn that control's back color to RED making that entire column red.
Numbers of colors you can see if you go to that control in design view and click '...' in the 'Back color' property

You can use the Rectangle control that you put behind the field control with the same principle, but above described way is visualy looking better to me.
And you can combine this code with If...Then statements to get different colors etc.
regards, H.