change field background color in report based on text

[calpolymis]

Hi. I want to change the background color of "item" field on Aceess report to yellow, if it contains text "special editoin."-without case sensitivity. How would I do this? Conditoinal formatting only enables number values, not text. Thank you for your help.

 

[dhookom]

You can use text or numeric values that evaluate to either true or false. For instance if I have a text box with job title and I want to highlight titles containing "rep", use Expression is:

InStr([Title],"rep")>0

Duane
Hook'D on Access
MS Access MVP

 

[calpolymis]

Hello, Duane. Thanks for your reply. So, is it something like this?

If InStr([Title],"rep")>0 Then
Me.[Title].BackColor = vbYellow
Else
Me.[Title].BackColor = vbWhite
End If

But where should I put that Expression if the above is correct? Thanks.

 

[dhookom]

My suggestion involved no code, only conditional formatting.

Duane
Hook'D on Access
MS Access MVP