How do I Automate changing text to a different text, ie, RW to RMW

R

RonW

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
 
T

Tom van Stiphout

On Fri, 13 Jun 2008 21:47:00 -0700, RonW

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.
 
R

RonW

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
 
Top