Hi All,

I have a recordset working with a translation table, please have a look at my below code:

Dim rst As Recordset
Dim strSQL As String
Dim DB As Database
Dim stringText As String

strSQL = "SELECT Translation FROM [FORMTEXT] WHERE Text_ID = " & text_id

Set DB = CurrentDb
Set rst = DB.OpenRecordset(strSQL)
rst.MoveFirst
stringText = rst!Translation

rst.Close
Set rst = Nothing
Set DB = Nothing

If text_id prefers to Latin characters, stringText is fine. However, stringText will be strange such as ??? ????????? ????, if text_id is non Latin characters such as Russian, Greek, or Chinese.

Please, give me some advice.

Thank you.