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