I have a query that gets all values from a table conditional on a value in another table. The query returns a truncated "long text" field; it only shows the first 255 characters. If I just open the table directly it displays the full text.
This is my query:
The field that's giving me trouble is Compositions.Composition. It is defined as "long text." I found one thread on a similar issue (which turned out to be an issue with an import from Excel, which is not my case) in which one suggestion was to change the text format to "rich text." (Although apparently for that to work you'd need to set it to rich text before importing from Excel so that's irrelevant.) So I'll mention that changing the field to rich text did not fix the issue.Code:SELECT DISTINCT Compositions.* FROM Discs INNER JOIN (Compositions INNER JOIN DiscContents ON Compositions.CompositionID = DiscContents.composition_id) ON Discs.DiscID = DiscContents.disc_id WHERE (((Discs.Status)<12));
Why isn't it giving me the full field contents? How do I fix it?