Hi there I have serveral tables that come from a SQL server. When the tables are linked to Access most of the fields have spaces before and after the data. In each table there is just too many fields to use the trim([field name]) on all of them. Is there a function that can update all the fields at once? Also is there a way that when the SQL tables are import or linked that the fields are automatically trimmed without having to do this if the trim all fields is not available. Thank you so much.