mulitple line labeling arcgis

Question

I try to label a field according to his length with VBScripting in ArcGIS 10.0

The idea is, if my field is more than a certain length, then please add a new line and split the field correctly. My field can be Null.

I can't get the code below to work (Verify returns nothing):

Function FindLabel ( [JOIN_NUMBER] ) If IsNull([JOIN_NUMBER] ) Then FindLabel = [JOIN_NUMBER] Else FindLabel = Left([JOIN_NUMBER] ,8) & vbnewline & Right([JOIN_NUMBER] ,Len([JOIN_NUMBER] ,-8)) End If End Function

Answer 1

Shouldn't it be:

Right([JOIN_NUMBER],Len([JOIN_NUMBER])-8))