I have a memo field that is a concatenation of 3 fields. The data for one of the three fields is copied and pasted from a Word document. Most of the time this works fine, but on a few occasions the last bit of text in the concatenated field is replaced by odd ASCII characters. The characters don't show up in the original field. I thought it was because of the concatenation at first, but the field allows me to put in more than 255 characters.
Here's a sample of what's happening (I can't paste the whole thing for client confidentiality reasons):
is in the final stages of the Planning and Leadership pha(rʸʸ
Unfortunately the characters won't paste exact, but that's the general idea. Help!