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?