Append Query Not pulling All Data (1 Viewer)

I have a linked back-end table that I am pulling data from with an append query. I am appending it to a local table. The query (Grouped) does not pull all the data from the back-end table. Here is what I have.

Field Name: ActionsTaken
Data Type: Long Text in both tables
# of Words: 66 (only 43 come over)
# of Lines: 7 (only 5 come over)
# of Characters: 355 (only 247 come over)

Anybody have any ideas?

Thank you.

the bad thing about long text is stupid microsoft only pulls the 1st 255 characters.
(because why would we want ALL our data)

you can google workarounds to try and get all the data. Not a lot of options.

That was it. I did find a workaround. You had to change the Text Format of the field from Plain Text to Rich Text. I found it at this link.

https://stackoverflow.com/questions/34279809/microsoft-access-2013-long-text-limiting-to-255

Thank you.