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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Keith said:
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?
Click to expand...

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
 
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."
 
Back
Top