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

Problem with some character showing up in the query

P: 10
Hi guys i have Access 2003 and im having a problem.
I have a query that gets information from another query and the problem that im having that in the first query there information aprears correctly like for example
"Misc. tracks playing Chinese Music incorrectly" but in the the next query it shows up like this "쀀" do you guys have any idea how i can solution this problem
Nov 15 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi guys i have Access 2003 and im having a problem.
I have a query that gets information from another query and the problem that im having that in the first query there information aprears correctly like for example
"Misc. tracks playing Chinese Music incorrectly" but in the the next query it shows up like this "쀀" do you guys have any idea how i can solution this problem
Is the relevant field a memo field by any chance. They're a nightmare to deal with in query manipulation. If at all possible change to text field.

The other possibilites are:

There is a carriage return character in the text. Access doesn't like them. If there is and they're necessary there is a substitute which is essentially a line down character and we can help with that.

The other horrific possibility is you have a corruption problem.

If you end up with only the last possibility come back and we'll try to help.
Nov 16 '06 #2

NeoPa
Expert Mod 15k+
P: 31,186
Before you check for all that stuff - do a 'Compact and Repair database' (From Tools \ Database Utilities' on your database and try it again.
If problem is fixed then :), otherwise we'll see what steps to take next as per previous post.
Nov 16 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Yeap it seems like Memo object....

But once i've had a corrupted line like this... Only one!

If this is for one line or few lines it seems to be corruption. If not a Memo object

And the thirt posibility is for not English speeking people that use other charcode than latin...

For exemple coz w're using cyrillic, the earlier versions of windows had other type of encoding that isn't the same as now. This encoding of cyrillic is read only by few Fonts like Hebar Courirer Cyr and when the Font is different there is a symbols like this displayed...

So verify also this coping from Access to Word and changing the Fonts for a while...
Nov 18 '06 #4

P: 10
Thanks guys it was like you guys siad it was the Memo and not Text so i changed it to Text and everything started working just fine great thanks for your help one again
Dec 15 '06 #5

NeoPa
Expert Mod 15k+
P: 31,186
No Problem.
Thanks for the response - That's always nice to receive.
Dec 15 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.