[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

-----Original Message-----
From: Michael R Mattys [mailto:mmattys at rochester.rr.com]
Sent: Friday, November 30, 2007 9:25 AM
To: Access Developers discussion and problem solving
Subject: Re: [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:

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************