Can this piece of code be optimized?
trying to pass some RecordSet values to an arryay, removing line feed and return carriage
Code:
        For i = 0 To 10
           If rs_Bills.Fields(i) <> Null Or rs_Bills.Fields(i) <> vbNullString Then 
                ValTMP = Replace(CStr(rs_Bills.Fields(i)), Chr(13), vbNullString)
                ValTMP = Replace(ValTMP, Chr(10), vbNullString)
                Valores(i) = ValTMP
                ValTMP = vbNullString         
            Else
                Valores(i) = vbNullString
            End If
        Next i
Really desperate about optimization...