Report

[idowu100]

I have merged a database and have produced a report based on a joint query. I need to be able to colour code the Incident numbers so that users can instantly know who to contact for a
particular query.

For example I have an incident number that begins with 0078 upwards and carries on for at least 14 pages and another Incident number starting with RSU 007 from pages 15 upwards.

How can I make these two numbers stand out.

GratEful for any suggestions.

 

[Tay]

Maybe you could try something like the code below. Just change IncidentNumber to whatever your control name is.

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

If me.IncidentNumber = "0078" Then

Me.IncidentNumber.BackColor = vbYellow
else me.IncidentNumber.backcolor = vbwhite
End if

End Sub

You'll need to check the properties for the control name and check that 'back style' is set to normal, not transparent.
HTH