<div>
in a union the field width gets defined by the first data to occupy the field.<br />
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)
</div>


in a union the field width gets defined by the first data to occupy the field.
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)

<div>
<div class="content wysiwyg-content">
I am having a a problem with a union query truncating a memo &nbsp;field to 255 characters. &nbsp;I've seen posts discussing this, but not a good answer. &nbsp;Here's the scoop:<br />
<br />
I have two queries, that each include a field that concatenates one string field with another memo field. &nbsp;When I surround the field with cstr(), each will properly extend beyond the 255 character limit. &nbsp;I have a UNION ALL query that combines these other two queries. &nbsp;This field is then truncated at 255 characters. <br />
<br />
How can I change this query to show the entire field? &nbsp;<br />
<br />
Two notes, 1) I did see Q208926. &nbsp;UNION ALL does not help. &nbsp;2) I know how to use a temporary maketable as a workaround. &nbsp;But that would be more inconvenient than usual in this case.<br />
<br />
Thanks for your thoughts.<br />
<br />

</div>
</div>


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.



Union query truncating memo field

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.