Append Query truncates data posted to a table memo field

[Lewis M]

I use a query is to create a new record in a table with values taken from
unbound controls on a form. Using an append query truncates data that is to
be posted in the table to a memo field.

I have defined the security of the user with the task of creating a new
record so that this user does not have the right to update an existing
record. Given these security restrictions, what routine can I use to create
a new row in my table without truncating the data to be posted in a memo
field?

 

[Allen Browne]

The SELECT part of your query must be performaing some kind of aggregation
on the memo field.

See:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

 

[Lewis M]

Thank you, Allen. I am looking over your tips to see which one relates to my
problem.