Updated: 26 October 2023
This GitHub repo demonstrates the unexpected truncation of a Long Text (Memo) field to a Short Text field, when creating a new table with SELECT * INTO.
https://github.com/ChrisTaylorDeveloper/ms-access-unexpected-truncation
A good explanation here also http://allenbrowne.com/ser-63.html