how to round labels

[STEVEHIRSCH]

I have three fields that I am trying to label and one that I am trying to round to the nearest whole number.  Here is what I have so far:

"Pipe ID: " + [ID_PIPE] & vbNewLine & [DIAM_INCH] + " in." & vbNewLine & Round ( [LENGTH_FT] ) + " ft."

I keep getting an error that says:

Error 1 on line 2.

Type mismatch: 'esri_2'.

I'm pretty sure it is related to the Round ( [LENGTH_FT] ) but I don't know what I'm doing wrong...

Thanks!

[DanPatterson_Retired]

Nice Xander... the declarative 'vars' and extra curly braces are reminiscent of those languages I have abandoned or chosen to avoid , but should I need to label anything, I will have your link on hand.