Adding New Fields - Allow Zero Length

[jempie]

All,

I am using an Make-Table query to add many new fields to a Table using Fieldname: "".

However, when I use this, it sets the Allow Zero Length to No.

Is there code that I can use to stop this happening?

I am using this method for multiple fields and across multiple tables.

Your help appreciated,

Jem

 

[reclusivemonkey]

FieldAttributeEnum in the VBA help files should... erm... help!