[AccessD] Trim in Access 2007

Hi Michael

Haven't followed this thread until now. 
Could you explain what you try to do? Clear as mud for me ...

/gustav

>> From: accessd-bounces at databaseadvisors.com on behalf of Michael R Mattys
>> Sent: Thu 11/29/2007 11:01 PM
>> To: AccessD
>> Subject: [AccessD] Trim in Access 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