G ganderson Sep 20, 2003 #1 what is the best way to find and replace data within a field using the access 2002 macro functions
K Ken Snell Sep 20, 2003 #2 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.
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.
