Highlight field

[brin]

Is possible to highlight using colour a certain field in a report e.g.
Report contains following:

Name Address Tenure
John the Road Freehold
John the Road Leasehold
John the Road Freehold
John the Road Freehold
John the Road Leasehold

I would like to highlight the FIELD/S in the TENURE column when it only contains Leasehold?????? I would only like to highlight the field in question and not the whole column?

 

[Mile-O]

Isn't there Conditional Formatting on your report?

 

[brin]

i have managed to highlight the forecolour on the report by using thre below, what is the code for highlighting the background?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.Tenure = "Leasehold" Then
Me.Tenure.FontBold = True
Me.Tenure.ForeColor = vbRed
Else
Me.Tenure.FontBold = False
Me.Tenure.ForeColor = vbBlack
End If

End Sub

 

[geraldcor]

You use "back color" in the preferences window. You can click the expression builder button to the side and it gives you a color wheel of sorts to choose the colors and gives you the number to use for that color. Do it just like you did but use backcolor instead and the appropriate number for the color.