Conditional Formatting in a report

S

souchie40

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
 
A

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
 
S

souchie40

Al,

Thanks that worked a treat

Souchie40

Al Camp said:
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
Click to expand...
 
Top