Michael R Mattys
mmattys at rochester.rr.com
Fri Nov 30 10:49:42 CST 2007
Gustav, I don't know, but I'll use your MTrim from now on. Thanks again. 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 11:06 AM Subject: Re: [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