On Sun, 11 May 2008 10:54:29 +1200, "Jason" wrote:

Wouldn't that inflate the file size?

No. Access does not store trailing blanks. A Text(10) field and a Text(255)
field occupy exactly the same space if each contains ten characters.

I would upgrade but too expensive for me.

A97 can change table definitions - using VBA code; it just doesn't support DDL
queries in the same way that later versions do.
--

John W. Vinson [MVP]