Memo field data is partially hidden until clicked on

[krausr79]

I have a table with a memo field. In one of the records, part of the data does not appear until the field is clicked-into. There seems to be a special character in there: If I use the right arrow to move through the text, it requires an extra press to move past the spot where the data does not show up.



I'm not able to see what that character is. If I try to use asc(mid([Field],64,1)) all it says is 0. If I highlight the full text and then copy/paste it into notepad, it only pastes up to what could be seen and truncates the rest. If I copy the table and change the field type to text, it truncates the rest.

I don't need the memo-ness of the field. None of the data is greater than 255 chars. Is there some way to view or convert the data so that all of it shows up? I have attached an example of the data

[aytee111]

Is this the only field like this? If so, retype the data. Is this a recurring issue? Update to left(..,64) & right(the rest).

[krausr79]

It does seem to be responding to len() correctly. In this case left(,64) & right(,len()-65) works by excluding the bad character. That will cover many of the cases I have (but not all). Any ideas for what to do if I don't know ahead of time where the bad character is?

[aytee111]

If it is always the same character, then InStr(field,Chr(0)) will find it.

[krausr79]

Oh, you're right! I thought asc=0 was just an error, but it really is 0! This is fixing things for me:
Replace([ClassDescription],Chr(0),"")