Hi,

I am trying to create a tool that will find data typed into one textbox and replace with data in another textbox as the user types, according to what is in different columns in a database. For example:

Column 1 has English words: "Hello", "Heat", etc
Column 2 has Spanish words "Hola", "Calor", etc

I have a MDB file with the English words in Column 1 alphabetized, and their Spanish corresponding words are in Column 2, on the same row, for example

Col1 Col2
Heat| Calor
Hello| Hola
Hot | Caliente
Is | Es
It | Es
Really| Muy

What I want to do is the following:

The user types "Heat" in text1, and the word "Calor" appears in text2. Or the user types "It Is Really Hot" in text1, and the words "Es Es Muy Caliente" appears in text2.

I'm using the ADO control to connect to the database using VB6.

From what I see, I need to

a)write a find command so the control queries the database on column(1) for the word typed.
b) move the query one column over, on the same row to get the Spanish word.
c) replace the English word with the Spanish word.
d) once the word has been replaced, move on to the next word being typed, ignoring the word that has been replaced as part of the query, so the database only queries for the word being typed, and not the entire phrase in text1, ie if I have replaced "Hot" with "Caliente" and then I type "Es", the database only queries for "Es" and not the string "Caliente Es".


Any help would be greatly appreciated. Thanks!