Re: Find And Replace

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tim (anonymous_at_discussions.microsoft.com)
Date: 03/02/04 

Date: Mon, 1 Mar 2004 20:47:45 -0800

John,

Thanks for your response. I think my question is not
clear.

I found a find and replace function (module) in Access 97
HELP that can find and replace string in module.

I need a help to modify that function to search the whole
word only.

Could you help me out?

Thanks again.

Tim.

>-----Original Message-----
>Check the Find Whole Word Only box in the dialog. That
should do it.
>
>Tim wrote:
>>
>> Hi folks,
>>
>> I found a find and replace function in Help(Access 97).
>> I tried to use it to replace "DB" by "database" in one
of
>> my module.
>>
>> But it didn't do what I expected. It replaced all
>> the "DB" by "database".
>>
>> Old_String New_String
>> strDB strdatabase
>> DB database
>> DBDate databaseDate
>>
>> I only want it change DB to database not the rest of
them.
>>
>> Could anyone show me how to modiy the function?
>>
>> Thanks in advance.
>>
>> Tim.
>.
>

Relevant Pages