Problem with some character showing up in the query

[ContractKiller]

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

[MMcCarthy]

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.

[NeoPa]

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.

[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...

[ContractKiller]

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

[NeoPa]

No Problem.
Thanks for the response - That's always nice to receive.