mlcktmguy
asked on
Memo field truncated in query
I am using a query to insert record from a combination of two tables into a third table.
One of the fields in the query is 'Comment' which is defined as 'Memo' in the table it is being pulled from and the table it's being inserted into.
One of the users noticed that the comment filed is being truncated if it's 'over a certain length'.
I just want to confirm that when a 'Memo' field is pulled into a query it may be truncated.
Does anyone know for sure if this i true and if it is true, how can I get around it?
One of the fields in the query is 'Comment' which is defined as 'Memo' in the table it is being pulled from and the table it's being inserted into.
One of the users noticed that the comment filed is being truncated if it's 'over a certain length'.
I just want to confirm that when a 'Memo' field is pulled into a query it may be truncated.
Does anyone know for sure if this i true and if it is true, how can I get around it?
The field is not truncated, but the expressions are compared using up to 255 characters of the memo (Long text) field.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the 2nd time today.