find & replace

[QsLx]

Hello,
I've been looking for a way to make find&replace action of
whole words within a field.
The point is, through all possible "match" options of the
find&replace dialog box, Access will not make any
distinction finding word ABC within the word ABCDEF
or the word ABC, even if these 2 words belong to the same
record/field ("ABC ABCDEF").

Neither there is (that I know) any built-in function who
may look for whole words within a (multi-words)field.

Can anybody help on this matter?

Thanks you very much.

Qslx

 

[Gary Miller]

If you need more flexibility, you will have to write your
own function to iterate through the records looking for the
conditions that you specify.

Gary

 

[qslx]

I guess that's the only way.

-----Original Message-----
If you need more flexibility, you will have to write your
own function to iterate through the records looking for the
conditions that you specify.

Gary





.