Is is possible to run a query to automate changing text in a field, so that
it will automatically for example change RW to RMW?

Thanks

On Fri, 13 Jun 2008 21:47:00 -0700, RonW
<(E-Mail Removed)> wrote:

One option is to in the <control>AfterUpdate write:
if Me.MyTextfield = "RW" then Me.MyTextfield = "RMW"

If you want this globally, run an Update query:
Update MyTable
set MyField = 'RMW'
where MyField = "RW'

-Tom.


>Is is possible to run a query to automate changing text in a field, so that
>it will automatically for example change RW to RMW?
>
>Thanks

Tom: Thanks for your reply. I'm a new Access user and I think I have found
a solution to my concern: I went to Find & Replace and it worked perfectly.
Thanks, RonW



"Tom van Stiphout" wrote:

> On Fri, 13 Jun 2008 21:47:00 -0700, RonW
> <(E-Mail Removed)> wrote:
>
> One option is to in the <control>AfterUpdate write:
> if Me.MyTextfield = "RW" then Me.MyTextfield = "RMW"
>
> If you want this globally, run an Update query:
> Update MyTable
> set MyField = 'RMW'
> where MyField = "RW'
>
> -Tom.
>
>
> >Is is possible to run a query to automate changing text in a field, so that
> >it will automatically for example change RW to RMW?
> >
> >Thanks
>