I am running Window7, Access2010. I have a table with several columns. I need to search for "-" and replace it with nothing. For example, data in the column is 12-345, I need to replace the "-" to nothing and data becomes 12345. I have used sendkeys with replace in Access97 and now it doesn't work anymore. Can someone please help? It is time critical. Thank you.