SQL Reporting Services Expression to evaluate if field is null &| white space

Question

I'm making a report and in a text box I want to show the Tax ID of a entity if one exists. However if a tax ID doesn't exist then that field is just white space. So if the field is white space I want to show nothing in the text box.

IIF(IsNothing(Fields!TAX_ID.Value), "", "Tax ID: " & vbCrLf & Fields!TAX_ID.Value)

What do I do?

Answer 1

However IsNothing might not always evaluate it properly. Might try:

IIF(Trim(Fields!TAX_ID.Value) = "", "", "Tax ID: " & vbCrLf & Fields!TAX_ID.Value)