[AccessD] Trim in Access 2007

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