Michael R Mattys
mmattys at rochester.rr.com
Thu Nov 29 22:01:23 CST 2007
All fields in table defined as TEXT (39) I wrote: For Each fld In oDB.TableDefs("CASS").Fields qdfTrim.SQL = "UPDATE CASS SET CASS.[" & fld.Name & "] = Trim([" & fld.Name & "])" qdfTrim.Execute Next When I do a Len(AnyField), they are all 39. How do I know if Trim() worked or not? What's going on here? Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com