I need to find a word in a sentence. I need to find the exact word in a sentence. Here is the example.

I need to find "Red" in the sentence below.

"I have a Red car." If "Red is found, I can update a field. I know how to use the instr function, but it is not working for what i need.

What I am doing is searching a description field for a color, if the color is found in that field, I update another field in that record.

Any help would be great. Thanks.

can you show us the code you are using?? instr should be working ok. Maybe you have another problem?? (like CAPS??)

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

I haven't done the code yet, because I haven't figure out the best way to do it. Here is what I am trying to accomplish.

I have a master color file. The file has two fields in it. ColorName and SLName. The purpose of this file is to use the ColorName and search another file field to find the ColorName. If the ColorName is found in the field, I update a field in that file with SLName. This is EDI related. The customer enters information in a field like "SOFA 2-SIDE RED".

but your original post reads: "I know how to use the instr function, but it is not working for what i need"

So, did you even try it?? or you need the full code??

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

I need a good code example of how to do this. I am programmer, but I am new to the Access 2007 VBA code. Any help would be great. Thanks