Hi Bonnie,

Not sure if iif function supports that type of coding. Its seems to be getting confused and will not let the result = decision of the iif( function. Like its trying to return the true/false instead of the values.

This code works, but too much coding.

     Dim strAPN As String
     If myDataRow("APN") Is DBNull.Value Then
         strAPN = "Null"
     Else
         strAPN = myDataRow("APN")
     End If
     MessageBox.Show(strAPN)


This does not work - Error Cast from type 'DBNull' to type 'String' is not valid.
     MessageBox.Show(IIf(myDataRow("APN") Is DBNull.Value, "", Trim(myDataRow("APN"))))

Next year Mircosoft may have all the bugs fixed, NOT.

Have a Happy New Year!!!!!!!!!!!!

Thanks for all your help and all the other professionals on these forum.

Sincerely,
Roland

==========================================================================

>Dunno Roland ... it sure looks like it should work (but I haven't used the IsDBNull() function). How about trying this intead:
>
>

>
>IIf(MyDataRow("APN") = DBNull.Value, "", Trim(MyDataRow("APN"))
>

>
>~~Bonnie
>
>>Hi,
>>
>>I encountered the following error message with the code below the error message.
>>
>>An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll
>>Additional information: Cast from type 'DBNull' to type 'String' is not valid.
>>
>>MyEmailBody = myDataRow("AccountId") & " " & _
>>myDataRow("OrderNumber") & " " & _
>>IIf(IsDBNull(myDataRow("APN")), "", Trim(myDataRow("APN"))) & " " & _
>>IIf(IsDBNull(myDataRow("StreetNumber")), "", Trim(myDataRow("StreetNumber")))
>>
>>What is the proper code to cancanate the string?
>>
>>Any help would be greatly appreciated.
>>
>>
>>Thanks
>>Roland