Yes and yes. I ended up changing the data type to text rather than memo and it "solved" the problem. But that limits the number of characters allowed compared to Memo. Josh
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mick_curtis Sent: Friday, November 17, 2006 8:45 AM To: [email protected] Subject: [Access VBA Central] Re: Unicode Issue in Access Query Just playing with the problem... If you trim the memo text to 255 characters (with a left() function), do you have the same problem? Is there any "group by" or function being used? Mike --- In [email protected] <mailto:AccessVBACentral%40yahoogroups.com> , "Josh Haley" <[EMAIL PROTECTED]> wrote: > > Group, > > I have a database that was set to compress a memo field using Unicode. > When I run a query to return all records, the memo field looks fine. > When it is filtered to show only certain records, the field shows the > strange characters instead of the uncompressed data (looks like symbols > or Asian characters). > > I already reset the field to NOT use Unicode compression, the tried > again, and the result is the same. Any ideas would be greatly > appreciated. > > Thanks, > > Josh > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
