FORMATTING

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

Guest

I have windows xp and office2003
In my report i am trying to format a field so that when anyone of the
following appears in that field i can flag it. C+, B, B+, A ,A+ I CAN DO
THREE OF THEM BY USING AN EXPRESSION like [field]="C+" but now i used up my
3 expressions and i still need to flag A,A+
Thanks for any help
ed
 
I have windows xp and office2003
In my report i am trying to format a field so that when anyone of the
following appears in that field i can flag it. C+, B, B+, A ,A+ I CAN DO
THREE OF THEM BY USING AN EXPRESSION like [field]="C+" but now i used up my
3 expressions and i still need to flag A,A+
Thanks for any help
ed
Click to expand...

Change the ForeColor or the BackColor?
Use the Report's Detail Section Format event (if the control is in the
Detail Section):
If [ControlName] = "C+" then
[ControlName].ForeColor = vbRed
ElseIf [ControlName] = "B" Then
[ControlName].ForeColor = vbBlue
Elseif .... etc.
Else
[ControlName].ForColor = vbBlack
End If
 
Back
Top