How to fix access 2016 form truncates memo field from queries w/2 tables

[LINOZE]

I have 2 tables with several longtext fields. I joined the tables in a query. I then created a form drawing data from both tables. However, all the memo fields in the form were truncated.

I researched it and came up with change "union" to "union all" in sql view. If that's true, i have no clue how to do this. Please help.



Len

[CJ_London]

I researched it and came up with change "union" to "union all" in sql view. If that's true, i have no clue how to do this. Please help.

if you want help with a query, always helps to post the sql to the query (in query design view click on the sql option bottom right of the window), then copy paste to the thread.

you might find this link helpful

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

if you are using a union query then you will be using sql anyway since this cannot be done in the query gui