Multiline multicolred labels

[HemantAngarkar2]

I am trying to create multiline multicolored labels on States layer of template data; following code is not working.

Function FindLabel ( [STATE_NAME], [STATE_ABBR], [SUB_REGION] )

  FindLabel = "<CLR red = '255'>" + [STATE_NAME] &  vbnewline & "<CLR red = '255'>" + [STATE_ABBR] & vbnewline & "<CLR red = '255'>" + [SUB_REGION]

End Function

Kindly help.

[KenBuja · Accepted solution]

This works

Function FindLabel ( [STATE_NAME], [STATE_ABBR] , [SUB_REGION]  )
  FindLabel ="<CLR red = '255'>" & [STATE_NAME] & "</CLR>"  & vbnewline  & "<CLR green = '255'>" & [STATE_ABBR] & "</CLR>"  & vbnewline  & "<CLR blue = '255'>" & [SUB_REGION]  & "</CLR>"
End Function

[HemantAngarkar2]

Thanks Ken