Remove spaces from a string

I’d like to remove all of the spaces from every string value contained in a particular column of an Access 97 table. I’d like something a little easier than looping through a DAO recordset, but that will do if someone can help me with the code as I’m a bit rusty. Thanks!