Linked Table Memo Field Corruption

[aesseal]

I have an oracle table linked into as access 97 database. This all works fine, apart from a memo field in the table. The memo field shows only the first letter. When the cell is highlighted it shows all of the letters seperated by the little square character that means it doesn't recognise a character.
The same database works fine on other PCs.

Has anybody got any ideas???

Dan

 

[thecreator]

Sounds like the memo field is full of carriage returns.
You could try passing it through this function and seeing if you can now see the first two characters .. if so, then just change this function to remove all carriage returns instead of just the first that it finds and you would be OK I think.

Function Remove_Ch13(inpvalue As String) As String

'Find char 13 in the string and replace it with " "
Dim StrLen, i
StrLen = Len(inpvalue)

Do
i = i + 1
Loop While Asc(Mid(inpvalue, i, 1)) <> 13 And i <> StrLen

Remove_Ch13 = Left(inpvalue, i - 1) & " " & Right(inpvalue, StrLen - i)

End Function

Hope this helps

 

[aesseal]

The same field is displayed correctly on my PC, so there can't be any carriage returns, it just doesn't display correctly on another.

Dan

 

[aesseal]

I finally fixed it by adding the registry key:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"NLS_LANG"="ENGLISH_UNITED KINGDOM.US7ASCII"

Dan