Can't combine memo & Text fields in a query.

  • Thread starter Thread starter David
  • Start date Start date
D

David

When adding anything in a query next to a field with Data
type = Memo, like this
Combined: [Inventory] ![Product] & [Inventory]![price]
Or
Combined: [Inventory] ![Product] & "instock"
The query will not display more than 256 characters.
(The field [Products] is a Memo type, and the properties
is set to Unicode Compression = Yes)

How do fix this problem?

Thanks
 
David said:
When adding anything in a query next to a field with Data
type = Memo, like this
Combined: [Inventory] ![Product] & [Inventory]![price]
Or
Combined: [Inventory] ![Product] & "instock"
The query will not display more than 256 characters.
(The field [Products] is a Memo type, and the properties
is set to Unicode Compression = Yes)

How do fix this problem?
Click to expand...

What version of Access, and what version and SP of Jet? Install the
latest SP of the appropriate Jet version and see if it fixes the
problem. If you're using Access 2000 or 2002, and hence Jet 4.0, you
may want to install Jet SP 6 instead of SP 7, because I've heard a few
reports of some people having problems with SP 7 (though I'm using it
and haven't had any trouble yet).
 
Back
Top