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

A

Abe

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
 
Top