My memo field in a query is being truncated to only display 255 characters. When this query is used in my report the same thing happens.
The field is set to memo in the table.
This is a "query" forum. Please post the SQL of your query. I expect you have Group By or DISTINCT or similar in the SQL but I can't tell from my perspective.
Duane
MS Access MVP
Find out how to get great answers faq219-2884.
Dhookom,
Thanks for responding to my problem.
Since commencing this thread further investigation has shown that the table in which the query was based only included information that was already truncated to 255. This appears to have been created when using an output macro to an excell spreadsheet then importing the information into my current table. Somewhere in the process of going from database to excell I have lost anything beyond 255 characters.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.