Stacking labels of one field.

2488
1
09-07-2011 10:10 AM
KimballHansen
New Contributor
Someone had this same question ten years ago on another closed thread and it still wasn't answered. Is there a way to stack labels to two lines instead of one? I am referring to only one field being stacked. I have many State Highways and US Highways and instead the label showing US 193 or LA 345 I would like it to be:

US
193

or

LA
345

Could you help me with that? Thanks.

Kimball Hansen
Tags (2)
0 Kudos
1 Reply
BinChen1
New Contributor II
When you setting the label, use expression instead of field.

Here is an example:

Left([STREET], instr([STREET], " ")) & vbCrlf & Right([STREET], len([STREET]) - instr([STREET], " "))

Hope this helps.

Bin
0 Kudos