Hyperlink fields returning 1 funny character

[machumpion]

I'm querying a field in a customer table that contains customer email addresses. The output does not return the hyperlinks actually in the customer table though. Instead, I get a singular foreign character of unknown origin. How come this is happening? What can I do to fix this?

Thank you!

 

[NauticalGent]

Can you describe the character?

 

[NauticalGent]

Try copying and pasting it using this link...it will return the ascii value. It will help narrow down what the issue is.

http://www.asciivalue.com/

 

[machumpion]

The characters are of all kinds, from chinese to korean to random symbols:
Email
팀*
팀*
�*
�*
�*
�*
�*
�*
�*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*

I noticed that this only happens when I include a field from a related table in query design. Strange.

 

[NauticalGent]

Chinese characters...are you grouping on a memo field in your query?

This might be helpful:

https://access-programmers.co.uk/forums/showthread.php?t=204290

 

[sneuberg]

What kind of query are you running? I've seen foreign characters in the Datasheet View of update and append queries if the field is not text. But the update and append work ok in spite of it. You could try apply CStr to the field and see if you get different results, i.e, an expression like:

DisplayField: CStr([TheFieldName])