Chinese characters appear

[lsj6020]

i have a multi-user database set up and after entering data, in some
qualitative fields in some cases, at some point, it converts to chinese
characters! I have seen them! I am stumped as to why and also stumped
as to how to get this to cease and desist! Any ideas?

 

[Ken Snell \(MVP\)]

Are you seeing these characters in the table? or in a query that you run
using data from the table?

This is a common result of doing a Group By on a memo field in a query.
Change the field to a First([NameofMemoField]), assuming that the record is
unique enough in the query's selected fields that only one memo field's
value will be possible.