<div>
The field is not truncated, but the expressions are compared using up to 255 characters of the memo (Long text) &nbsp;field.
</div>


The field is not truncated, but the expressions are compared using up to 255 characters of the memo (Long text)  field.

<div>
Thanks for the 2nd time today.
</div>


<div>
<div class="content wysiwyg-content">
I am using a query to insert record from a combination of two tables into a third table.<br />
<br />
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.<br />
One of the users noticed that the comment filed is being truncated if it's 'over a certain length'. &nbsp;<br />
<br />
I just want to confirm that when a 'Memo' field is pulled into a query it may be truncated.<br />
<br />
Does anyone know for sure if this i true and if it is true, how can I get around it?
</div>
</div>


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?

Memo field truncated in query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.