By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Oct 28 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Oct 28 '08 #2

P: n/a
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" <AllenBro...@SeeSig.Invalidwrote:
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.
Oct 30 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.