static function and memo fields

[Les]

Has anyone had a problem like this? I'm using a static
function within an append query to process a table (where
key information appears in different rows) and append the
concatenated results into another existing table. I use
the static function to hold onto the key information. I
use an append query to maintain memo datatype for the
concatenation.
Once I have the key information, the static function
calls another function to match against another table.
When the 2 match, I want to return a concatenated value to
the static function. The concatenated value is made up of
memo fields.
This process works for the majority of the data. The
exceptions seem to be when the concatenation is greater
than 255 characters. (I'm guessing). Then, the following
occurs.
When using the debug tool, it looks like everything is
working correctly. The concatenated results are returned
to the static function. The end of the function is
reached, but the next row of data is not retrieved. It's
still on the current row.
If I substitute the 2nd memo field with a long
literal, exceeding 255 characters, it works correctly.
Any help would be greatly appreciated. And I hope I
described this accurately.

Thank you.

 

[[MVP] S.Clark]

What is a static function?

Access has many problems when it comes to appending memo field data. Search
Google Groups for "Memo Field 255", and you'll get a wealth of results. Read
through them and see if anyone has an elegant solution that would help you.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-