I'm trying to label a field "MaxGrantee" that has some rather long named entries that are going outside of their polygon and overlapping other labels. I have read other posts and have found this expression: left([MaxGrantee] ,InStr(20, [MaxGrantee] ," ")) & vbnewline & right( [MaxGrantee] ,len( [MaxGrantee] )-(InStr(20, [MaxGrantee] ," ")))
But it will not work. All is get is an error saying: Error 1 on Line 2. Invalid use of Null: 'InStr(...)'.
Does anyone have an ideas of what I'm doing wrong?
I'm in 10.2.2 version 3552
I'm labeling from a personal GDB. Thanks##