SQL Server Performance Forum – Threads Archive
IIF Function
can i use an IIF function to make an textbox on my report look continuous in this situation?: i have 2 db fields, addressline1 and addressline2, and i want it to look continuous. if addressline2 is null, then i want it to look like: nameaddressline1
city, state zip if addressline2 is not null, then i want it to look like name
addressline1
addressline2
city, state zip IIF(addressline2 = null(i cant get this logic to work either), fields!name.value & vbcrlf & fields!addressline1.value & vbcrlf & fields!city.value & ", " & fields.state.value & " " & fields.zip.value, !name.value & vbcrlf & fields!addressline1.value & vbcrlf & fields.addressline2.value & vbcrlf & fields!city.value & ", " & fields.state.value & " " & fields.zip.value) Joe Janka
]]>