Column Value gets truncated, Any type Conversion needed?

[konquistador]

Hi Gurus, need your help yet again.
I have a linked table in Access 2007(link back to SQL Server), and when i look into the values of a 'Memo' Column called "Column_1" in Access, it is just fine.
Now, In a query I am doing the following IIF statement:

Expr1: IIF([table_1].[Column_2]="Cost",[table_1].[Column_1]

But when i see the values of Column_1 now, some of the ending characters are being cut off, i only get half of the entire text.
Should i be doing any type-casting or anything to bring the entire text?

Any help is appreciated.

Thanks,
Kon

 

[ajetrumpet]

Should i be doing any type-casting or anything to bring the entire text?

Not sure, but your IIF statement is incomplete anyway...

IIF([table_1].[Column_2]="Cost",[table_1].[Column_1], [COLOR="Red"]where's this portion?[/COLOR])

Or, is that part of the problem, I wonder?

 

[konquistador]

Hi, Okay I will re-check my IIF statement, but that doesn't solve the problem.
When i just join this table to another table and pull the column into the query, it still shows truncated values in the Column_4. (Which is also a memo field, No formulas used here,and if i just see values from original table without any join, i see all values). There should be something i am missing in the query? Any ideas?

Thanks,
Kon

 

[neileg]

Is the text longer than 255 characters?
http://allenbrowne.com/ser-63.html