RTrim problem - not removing trailing spaces

[Terkle]

I imported a text field from Excel into an Access table. I tried to link it to another table in a query but it didn't work as the imported field has four spaces after the last character. I ran an update query using the RTrim$ function but it doesn't get rid of the spaces so I have to manually delete them. The text in the field is not the same length in each row otherwise I presume I could use the Left$ function??

Has anyone got any suggestions as to how I can clear these trailing spaces?

Thanks for any suggestions.
terkle

 

[Remou]

I think that you will find that the character is Ascii 255 or 160. You can find out and use Replace to remove it.

Sub WhichChar()
Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("ATable")

For i = 1 To Len(rs!AField)
Debug.Print Asc(Mid(rs!AFileld, i, 1))
Next
End Sub

 

[Remou]

Tut,

[tt]Debug.Print Asc(Mid(rs!AField, i, 1))[/tt]