Ok, so here is the expression I got to sort of work:
"Open: " & ['Quick Leasehold Cursory 9-11-12$'.F2] & vbnewline & ['Quick Leasehold Cursory 9-11-12$'.F4] & vbnewline & "HBP: " & ['Quick Leasehold Cursory 9-11-12$'.F3] & vbnewline & "Competitor: " & ['Quick Leasehold Cursory 9-11-12$'.F5] & vbnewline & "# of Leases:" & ['Quick Leasehold Cursory 9-11-12$'.F6]
I left out labeling the label, as the sections show like this:
Open:
CHK,oil co, oil co
HPB: 640
This seems to work and will be sufficient but there are two issues:
1. The 2nd line where it says CHK etc is operator data, sometimes this string goes on having to list all the operators. Is there a way to stack these to make them appear cleaner on the map?
2. I gone round and round with the scaling but some of the labels wont appear at the scale i need to print the map. If I zoom into one that is not labeled, the label will appear with the correct expression.
Help!