Using Expression Builder to Replace text in Column

[kent]

I'm trying to remove a particular string that exists throughout the text in cells from a single column....
Table Name: MAIN_Articles
Column Name: Content
String to remove: "color=black"

I tried adding a command button to a blank form, and with expression builder created the phrase: =Replace([MAIN_Articles]![Content],"color=black"," ")

However, when I click on it I get the error "The expression On Click you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'MAIN_Articles'



I'm not sure where to go from here. Anyone have any thoughts? Thanks!

[Bob Fitz]

IF I've understood your requirement correctly, you could just run an Update query. Something like:

UPDATE MAIN_Articles SET MAIN_Articles.Content = ""
WHERE (((MAIN_Articles.Content)="color=black"));

MAKE A BACKUP FIRST in case this isn't what you need.

[kent]

Thanks, I'm going to try this.

[Bob Fitz]

Thanks, I'm going to try this.

Good luck. Let us know how you get on. Don't forget that backup.