Ok here is another question.
Lets say some of the HOUSE ID fields are empty, how would you modify the expression to say that if the HOUSE is empty/NULL use ACCESS NUMBER to label?
Function FindLabel ( [HOUSE], [NUMBER] ) If IsNull( [HOUSE] ) then Findlabel = [NUMBER] Elseif IsNumeric( [HOUSE] ) then Findlabel = [HOUSE] & [NUMBER] Else FindLabel = [NUMBER] & [HOUSE] End if End Function