[AccessD] Replace text in memo field

Mark A Matte markamatte at hotmail.com
Fri Nov 23 14:50:44 CST 2007


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



More information about the AccessD mailing list