djxerx
asked on
Union query truncating memo field
I am having a a problem with a union query truncating a memo field to 255 characters. I've seen posts discussing this, but not a good answer. Here's the scoop:
I have two queries, that each include a field that concatenates one string field with another memo field. When I surround the field with cstr(), each will properly extend beyond the 255 character limit. I have a UNION ALL query that combines these other two queries. This field is then truncated at 255 characters.
How can I change this query to show the entire field?
Two notes, 1) I did see Q208926. UNION ALL does not help. 2) I know how to use a temporary maketable as a workaround. But that would be more inconvenient than usual in this case.
Thanks for your thoughts.
I have two queries, that each include a field that concatenates one string field with another memo field. When I surround the field with cstr(), each will properly extend beyond the 255 character limit. I have a UNION ALL query that combines these other two queries. This field is then truncated at 255 characters.
How can I change this query to show the entire field?
Two notes, 1) I did see Q208926. UNION ALL does not help. 2) I know how to use a temporary maketable as a workaround. But that would be more inconvenient than usual in this case.
Thanks for your thoughts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
put the results that return memo data at the beginning of your query and it might work (I don't know how else you can force a type in Access queries)