Replace Function for Global Table Changes

[rjstephan]

In Access 2002 how do I use the VBA Replace function to search all fields in a table and change all occurences of "ABC" to "XYZ"?
Thanks in advance.

 

[dynamictiger]

Create a recordset the way you want to ADO or DAO.

Loop through the recordset in the field you want to alter.

Use Replace as follows:

Do until .eof

.fields("myField&quot=Replace(.fields("myField&quot,"ABC","XYZ&quot

.MoveNext

Loop

Should do it. I haven't tried it.

 

[rjstephan]

I wanted to avoid looping thru all possible fields individually. If you use the Replace command off the menu in a table you can search and replace all fields in the entire table at once -- that's what I would like to do with a function. Thank you.