If the [Situs_Unit] field is blank on the parcel layer I would like the # sign to not show on the map labeling. Is there a way this can be accomplished?
This is my label expression for my parcel layer. [Situs_Num] & " " & [Situs_St] & " # " & [Situs_Unit]. If the parcel has info in this field, [Stius_Unit], it looks like this: 103 Park #421. If the parcel has no info in the unit field it looks like this: 124 Park #. is there a way in the expression to remove the # sign if the field is blank?
Thank you,
Linda Jo
