Update table query memo field truncated

[SwissMiss]

I am using access 2000. I have an update query defined with one parameter
(defined as memo data type). The field in the table to be updated is also
memo type. However, when I run the query, the data is always truncated.

When I view the SQL, even though the parameter is defined as memo, in SQL it
shows as text. When I tried changing the data type in SQL to longtext, it
didn't help.

Does this mean that you cannot update a memo field using an update query?

Help needed quickly. THanks in advance

 

[John Vinson]

I am using access 2000. I have an update query defined with one parameter
(defined as memo data type). The field in the table to be updated is also
memo type. However, when I run the query, the data is always truncated.

When I view the SQL, even though the parameter is defined as memo, in SQL it
shows as text. When I tried changing the data type in SQL to longtext, it
didn't help.

Does this mean that you cannot update a memo field using an update query?

Help needed quickly. THanks in advance

Please post the SQL. It's certainly possible to update memo fields
without truncation. There are things that will inhibit this (such as
attempting to sort by or to format) the memo field; if you post the
SQL someone may be able to spot the difficulty.

John W. Vinson[MVP]

 

[SwissMiss]

SQL
PARAMETERS rptFooter Text;
UPDATE tblLocalValues SET tblLocalValues.rptMeetingsAllInfoFooter =
[rptFooter];

Please note:
- in tblLocalValues the field rptMeetingsAllInfoFooter is a memo field with
no index and not required. I am merely holding a string there that may be
greater than 255 characters.
- that in Query design view, the parameter rptFooter was set to memo.
However in SQL view it shows the above.
I also tried changing the slq so that the first line read
- PARAMETERS rptFooter LongText;
I also tried
- PARAMETERS rptFooter Text(500);

Nothing worked. I appreciate your interest and would love a reply. I am
working strictly in Access 2000 DAO database. Nothing special. Thanks.