Similar to the format command or using Cdbl(0) to create a Double field, is there a way to set a text field's length using a standard MS Query ie; FieldName: FieldLen = 4
I want to set the length of the field when a MakeTable query is run. The initial query will create a table with some empty text fields that I will update later. There are quite a few of these fields and thay default to a size of 255. This will eventually cause the size of the Db to become too large.
The query would be similar to <FieldName:"SpaceFiller".>
"SpaceFiller" would be the maximum length of any data updated in the field, therefore, I don't need fields 255 Char's long.
I want to set the length of the field when a MakeTable query is run. The initial query will create a table with some empty text fields that I will update later. There are quite a few of these fields and thay default to a size of 255. This will eventually cause the size of the Db to become too large.
The query would be similar to <FieldName:"SpaceFiller".>
"SpaceFiller" would be the maximum length of any data updated in the field, therefore, I don't need fields 255 Char's long.
