How to allow zero length strings with DDL statement 1

[klm2klm2]

I have a DDL statement similar to this:

alter table blah_table
add column
blah_column char(20);

The statement *does* add the new column. However, I want the "Allow zero length" column property to be set affirmatively.

How can this be done in a DDL statement?

If it can't be done with DDL, how can it be done in a programatic manner? This action needs to occur as part of an application revision upgrade routine.

Thanks,
Kim

 

[mikevh]

I don't know of a way to do this with DDL (though
there may be a way I don't know about), but it can
be done programmatically by setting the field's
"AllowZeroLength" property to True.

I was able to set this property for a field in a
test table from the Immediate Window like so:

currentdb.TableDefs("testtable&quot("testfield&quot.AllowZeroLength = True