Does anyone know how to trim blank spaces from Access text fields?

I want to loop through all of the tables and all fields in the table and check to see if it is type string. If it is, then I want to trim the field's value to get rid of spaces.

Thanks.