[AccessD] Trim in Access 2007

Hi Michael

It could be that Trim on its own is a native function of JET SQL while using a custom function will call Trim of VBA.

/gustav

>>> mmattys at rochester.rr.com 30-11-2007 16:54 >>>
Hi Rusty,

No, still the same old field definitions (afaict)
Gustav's function works, I don't know why Trim wouldn't.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com 

----- Original Message ----- 
From: <rusty.hammond at cpiqpc.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, November 30, 2007 10:39 AM
Subject: Re: [AccessD] Trim in Access 2007


> Not having worked with Access 2007 this is just a wag, but in SQL you can
> set a field as char (fixed length text) or varchar ( variable length 
> text).
> Is this same capability in Access 2007 and could it be that your field 
> type
> is set to fixed length?
>
> Rusty