Help with setting Access Memo field restrictions using DDL

[Scott Van]

Hello-

I am trying to create an Access table using DDL that has a memo field.
I have the syntax to create the memo field but I can't find the syntax
to also set whether the memo field should allow zero length. I can set
this option using the Access interface directly, but I want to create
this table and this column definition using a DDL script. Listed below
is the script that works but I just need the syntax to set the
additional setting of allowing zero length.

The field in question is the instructions memo field.

The DDL script I have so far is:

CREATE TABLE Media_schedule (
Schedule_id AUTOINCREMENT constraint Primarykeyname Primary Key,
Media_type_id INT ,
Group_id INT ,
Media_id INT ,
Status INT ,
Delivery_time_e ncoded CHAR (10) ,
Delivery_date_s ysformat datetime ,
Pickup_time_enc oded CHAR (10) ,
Pickup_date_sys format datetime ,
Customer_id CHAR (20) ,
Address CHAR (100) ,
Building CHAR (100) ,
Room CHAR (100) ,
Phone CHAR (50) ,
Instructions memo ,
Contact CHAR (100) ,
Event_descripti on CHAR (100)
);

Thanks

Scott Vanderlip
Internet Software Sciences (http://www.inet-sciences.com)