C-Sharp (C#) Group: Access IIF statement cutting off my string

I have a field with data type of memo in my access database.
 I run a
query from c# to access this field and it cuts off my string
to only
255 characters.   If i run this query directly in access it
works fine.
 If i run this query without the iif statement it works
fine.  It only
cuts off my string when i run this query in c# WITH the iif
statement.
Here is the statement that doesn't work.

SELECT
      IIF(ISNULL(t1.field1), t2.field1, t1.field1) AS desc
FROM
      table1 t1 LEFT JOIN t2 ON t1.field2 = t2.field2

If you run this in access it works.  If you change it to:

SELECT
     t1.field1
FROM
      table1 t1

it works fine.

It just doesn't work in c#.  Can anyone help


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "C-Sharp (C#)" group.
To post to this group, send email to C_Sharpgooglegroups.com
To unsubscribe from this group, send email to
C_Sharp-unsubscribegooglegroups.com
For more options, visit this group at http://groups.
google.com/group/C_Sharp
-~----------~----~----~----~------~----~------~--~---