find and replace

G

ganderson

what is the best way to find and replace data within a
field using the access 2002 macro functions
 
K

Ken Snell

Are you wanting to do this to the values for fields in a table? or for the
values for controls on a form?

If a table, create an update query, save it, and then use OpenQuery macro
action to make the desired changes.

If a form, use SetValue macro action and use an expression to set the new
value of the control.
 

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

Top