[AccessD] Replace text in memo field

Ok...that worked on XP...but it failed on A2k...is there a different function if I had to do this on a box with A2k?

Thanks,

Mark

> From: markamatte at hotmail.com
> To: accessd at databaseadvisors.com
> Date: Fri, 23 Nov 2007 20:50:44 +0000
> Subject: Re: [AccessD] Replace text in memo field
>
>
> I guessed it was something simple...I just never actually did this to data already in a table...it was always external files using vba.
>
> Thanks,
>
>
> Mark A. Matte
>
>
>> Date: Fri, 23 Nov 2007 15:25:49 -0500
>> From: fuller.artful at gmail.com
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] Replace text in memo field
>>
>> Anything wrong with Replace( [columnName], "searchTarget", "replaceString"
>> )?
>>
>> On 11/23/07, Mark A Matte wrote:
>>>
>>>
>>> Hello All,
>>>
>>> I have replaced text in a text file before...but If I already have the
>>> data in a table...and there is a 'phrase'/string I need to remove from the
>>> middle of a memo field...what is the best approach?
>>>
>>> Thanks,
>>>
>>> Mark A. Matte
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Put your friends on the big screen with Windows Vista® + Windows Live™.
> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_MediaCtr_bigscreen_102007
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
You keep typing, we keep giving. Download Messenger and join the i’m Initiative now.
http://im.live.com/messenger/im/home/?source=TAGLM