Truncated output from one table but not another. Both long text.

[fkneg1]

Hello,
I have been using Access 2013 to make a database which outputs values to PowerPoint.
I have two tables with data in which are both brought together in a query which is the recordset my VBA code relates to to output it to Powerpoint. Both tables contain data in 'long text' fields. The data from one outputs into PowerPoint textboxes without any issues regardless of the length of the data but the data from the other one is truncated to 255 characters. It definitely says it is a 'long text' field - is there any reason it would truncate the output?

Thanks

 

[redalert]

Text fields in Access are limited to 255 characters. You will not be able to enter more than 255 characters into the field. Any characters over and above this limited will be truncated.

Memo fields in Access 2010 can store up to 1 gigabyte of characters, or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in a text box control on a form or report.

I am not sure what you mean by a 'long text' field.

 

[fkneg1]

Thanks for your reply.

I am using Access 2013. For this version Microsoft have got rid of the memo field and replaced it with a long text field.

I can input the data into the table fine, its just when its outputted that it is truncated just from one of the two tables.

 

[CJ_London]

Long text is basically a memo field by another name. I would take a look at this link and see if any of the conditions described fit your situation

http://allenbrowne.com/ser-63.html

 

[fkneg1]

Thanks. That link was very helpful.
I had to set the "unique values" property of the query to 'no' and the "unique records" to 'yes' to get it working.