I'm having trouble with a large label expression and I keep crashing with an application error. I'm trying to display sample results as stacked:
Sample depth 1
Sample Depth 2
Sample Depth 3
Now, I also want each of those depths to have three criterias. (Regular, Bold, or RED) Depending on what the value exceeds. So for example:
As you see I have a depth field followed by the next three cells being the results based on their criteria. Could not figure out a way to color them based on their value. (<9.5 , >9.5, >45)
This is the VBScript I am currently using.
[MAP_ID] &vbnewline & [F5] & "<BOL>" & [F6] & "</BOL>" & "<CLR red = '255'>" & [F7] & "</CLR>" &vbnewline & [F9] & "<BOL>" & [F10] & "</BOL>" & "<CLR red = '255'>" & [F11_1] & "</CLR>" &vbnewline & [F13] & "<BOL>" & [F14] & "</BOL>" & "<CLR red = '255'>" & [F15] & "</CLR>"
I'm sure there is an easier way to do this...
I've tried changing blank values from null to " ", thinking this could be the issue, but no different result, still crashed..
Update, I have exported to shapefile so the attributes are no longer pulling from excel. Also, I have found that if i replace the blank spaces with a value (i.e. "-" or "NA") I do not have this same issue. Except the problem with this is that now I get labels like:
5 - -
It seems that the spaces tend to be the problem. Maybe an If Then statement is necessary?