[AccessD] Trim in Access 2007

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 




More information about the AccessD mailing list