[AccessD] Trim in Access 2007

I'm going to try this Trim replacement:
http://www.vbcode.com/Asp/showsn.asp?theID=967

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

----- Original Message ----- 
From: "Michael R Mattys" <mmattys at rochester.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, November 30, 2007 10:13 AM
Subject: Re: [AccessD] Trim in Access 2007


> Yes, that's what I had originally.
> Trim() does not appear to work at all
> I'll have to do it with a custom function like yours.
>
> Michael R. Mattys
> MapPoint & Access Dev
> www.mattysconsulting.com
>
> ----- Original Message ----- 
> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Friday, November 30, 2007 10:05 AM
> Subject: Re: [AccessD] Trim in Access 2007
>
>
>> Hi Michael
>>
>> Ignoring Trim for a moment, why not just execute a temporary query: