HElp!! memo field appears in query in chinese or japanese?

[sandy2011]

Hi FOlks,

can anyone help me?

table shows memo text fine..

but when i run a query its shows the memo field with text like: 였A and 愊` and 謍‹

 

[billmeye]

If you are trying to GroupBy a memo field it will not be able to and shows those characters. Use First to show the memo in a query. I believe queries will truncate to only show 255 characters of a memo field so if you want to show more in a report you may need to use Dlookup.

 

[sandy2011]

thanks bill for coming back to me....


If you are trying to GroupBy a memo field it will not be able to and shows those characters. Use First to show the memo in a query.

when i put in criteria to show 1 record it shows memo text fine..

i have 690 records and all of a sudden has just started with the funny characters...

would you happen to know why it has changed all of a sudden?

also Im not confident with dlookup and dont have time at min to look into it further..

is there a workaround?

 

[sandy2011]

I got a workaround to work!! (from suggestion from another thread on this site)

compact and repair seems to have solved the issue.. everything crossed it stays that way!!

shall wait and see!!!