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

  • Thread starter Thread starter RonW
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Change a text field (YYYYMM) to a date value 2
Problem with form--subform 5
Excel Automate IE with Excel onClick text 3
Text to date format? 0
Module To Import Text File Into Access Table 17
Word Automation And Pictures 1
Unpacking Data (i.e. 00001460{ in a text file) 4

Back
Top