perryc,
You are showing us that the field contains unprintable characters. We need to see the data in your table or form control.
Here is a query that displays the 1st, 2nd and 3rd (the asc and chr )and the first 20 characters of a memo field "fld" from table "memoTest".
Code:
SELECT memoTest.AName
, memoTest.AnimalId
, Len([fld]) AS L
, Asc(Mid([fld],1)) & " - " & Chr(Asc(Mid([fld],1))) & Chr(10) & Chr(13) AS Pos1
, Asc(Mid([fld],2)) & " - " & Chr(Asc(Mid([fld],2))) & Chr(10) & Chr(13) AS Pos2
, Asc(Mid([fld],3)) & " - " & Chr(Asc(Mid([fld],3))) AS Pos3, Left([fld],20) AS Strt20
FROM memoTest;
Sample data from my table
AName |
AnimalId |
L |
Pos1 |
Pos2 |
Pos3 |
Strt20 |
Spot |
1 |
1294 |
73 - I
|
32 -
|
104 - h |
I have a application |
Jim |
2 |
182 |
65 - A
|
114 - r
|
101 - e |
Are you a Windows 7 |
Sam |
3 |
772 |
78 - N
|
111 - o
|
116 - t |
Not long after Steve |
You can adjust the code to use your table and display the beginning of your Comment (memo) field. This will help identify the culprit characters.