Error message #Type!

[Vegaanders]

Hi!

I have created a report. One field I only want to show if it is not empty. I have done this in a textboc

="Expenses: "+[Expenses]

When field is empty it works, nothing is visible, but when it has a value I get the error: #Type!

What am I doing wrong?



Regards

Anders

[John_G]

You should always use "&" as the concatenation character.

The fact that it works is probably just a coincidence, because in the expression "Expenses: "+[Expenses], if [Expenses] is Null, the whole expression is Null.

Try: iif(isNull([Expenses]),"","Expenses: " & [Expenses])

[Vegaanders]

It say there is an extra ) somewhere. For me it looks OK

Anders

[John_G]

I don't see anything wrong, either. Did you have the leading "=" sign there? =iif(isNull([Expenses]),"","Expenses: " & [Expenses])

[Vegaanders]

I took it away and pated it again. And now it works perfect. Thanks!