I have a make table query where one of the columns is
left(Text,7) as Text1

Now when I view the design of the table it says the column is 255 characters long even though it is only 7 characters. Is there a way to do this through my query? I can't create the table before hand either.

Thank You for any help

Don't call a field "text". Reserved word.
Why can't you create the table and just append the records?
Delete the records when finished.

However even though the field allows for 255 characters it won't make the table any bigger since the extra places are not used.

If you really want to cut the field size you can edit the tabledef in VBA but you would need a good reason to bother.