Access: getting chinese (?) character unexpectedly, why?

[Tintin]

In a report in Access (11.65566.8821 SP2) I receive what appears to be
Chinese characters for one field only. I can't find the setting that
made that happen, I'd like to return that field to English. Anyone
know? Thank you.

[Allen Browne]

Is it a memo field? Or a concatenated query field?

Causes include:
a) You group by a memo field in a query that has a join on an unindexed
field:
http://allenbrowne.com/bug-18.html

b) There is a corruption on the table\:
http://allenbrowne.com/ser-47.html#M...angeCharacters

c) You create a query where Access does not understand the data type
correctly.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tintin" <E-**********@neiu.eduwrote in message
news:6d**********************************@p39g2000 hsb.googlegroups.com...

In a report in Access (11.65566.8821 SP2) I receive what appears to be
Chinese characters for one field only. I can't find the setting that
made that happen, I'd like to return that field to English. Anyone
know? Thank you.

[Tintin]

Hello! No it was not concatenated query but yes it was a memo field,
displying as a Chinese-looking character followed by a box (or just a
box if there was no value in that field). I tried changing Group By
to First, as your page recommended, but then Access required me to
enter a value for that field before viewing the report. But I changed
Memo to Text as field type and the problem is solved. Thanks for
pointing me in the right direction, I would not have found that.
Tintin

On Oct 28, 9:05*am, "Allen Browne" <[e-mail]:

Is it a memo field? Or a concatenated query field?

Causes include:
a) You group by a memo field in a query that has a join on an unindexed
field:
* * * *http://allenbrowne.com/bug-18.html

b) There is a corruption on the table\:
* * * *http://allenbrowne.com/ser-47.html#M...angeCharacters

c) You create a query whereAccessdoes not understand the data type
correctly.