I am using a select query off of a linked table (cannot change destination
table properties) and using TransferDatabase to convert query to dBase 5.0
file. I am using Left function on a double to return left 8 characters.
Problem is, conversion sets this field to 255 characters, which expands the
output file by like 9 times what it could be.

I want to set the field size in the select query to keep this down to 50
characters. Is there a way to do this? I also notice this happens when using
Make Table, under various scenarios. I would then have to go in and modify
the table manually or write code to change these sizes. Would be nice to take
care of setting the size of the text field within the query.

Using Access 2003.

Thanks,
Clint