Dim Ls_Phrase, Ls_Phrase_Envers, ls_temp As String Dim Li_compteur As Integer Dim ls_Sql As String Dim rst As New ADODB.Recordset Dim Cnn_connection As ADODB.Connection Set Cnn_connection = Application.CurrentProject.Connection If txt_source.Value = "" Or IsNull(txt_source.Value) Then Exit Sub Ls_Phrase = txt_source.Value For Li_compteur = Len(Ls_Phrase) To 1 Step -1 ls_Sql = "SELECT * FROM [legende] WHERE [source] = '" & F_String_For_SQL(Mid(Ls_Phrase, Li_compteur, 1)) & "'" rst.Open ls_Sql, Cnn_connection, adOpenDynamic, adLockOptimistic If Not rst.EOF Then Ls_Phrase_Envers = Ls_Phrase_Envers & rst![traduction] Else Ls_Phrase_Envers = Ls_Phrase_Envers & Mid(Ls_Phrase, Li_compteur, 1) End If rst.Close Next Txt_Reponse.Value = Ls_Phrase_Envers