set a report to color result sets, e.g. team A in blue B in red

[Keith]

I have a report that displays a group by different teams. I want the report
to color code the team in a report. IS there a way to do this?

 

[Rick Brandt]

I have a report that displays a group by different teams. I want the
report to color code the team in a report. IS there a way to do this?

What do you want to color? The background? The text?

Basically in the OnFormat event of the section where the color change takes
place...

Select Case Me!TeamID
Case 1
Me.Detail.BackColor = vbYellow
Case 2
Me.Detail.BackColor = vbRed
etc...
End Select

 

[Al Campagna]

Keith,
You could use the OnFormat event of the report section you want colored.
If Team = "A" Then
'set all the fields forecolor to red
ElseIf Team = "B" Then
'set all the fields forecolor to blue
'etc... for all teams
End If

or... use a Select Case statement to do the same.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."