Conditional Formatting in a report

[Guest]

Hi everyone,

Is it possible to do conditional formatting in A97? if so how would I format
a text box on a report such that if the box contains the word 'REPAIR' it
will be highlighted in a different colour and bold?

MTIA

 

[Al Camp]

souchie40,
Use the OnFormat event for the section that contains "Repair".
(use your own names)
If SvcType = "Repair" Then
SvcType.FontBold = True
SvcType.ForeColor = QBColor(12)
Else
SvcType.FontBold = False
SvcType.ForeColor = QBColor(0)
End If

 

[Guest]

Al,

Thanks that worked a treat

Souchie40

souchie40,
Use the OnFormat event for the section that contains "Repair".
(use your own names)
If SvcType = "Repair" Then
SvcType.FontBold = True
SvcType.ForeColor = QBColor(12)
Else
SvcType.FontBold = False
SvcType.ForeColor = QBColor(0)
End If

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions