Create table: Allow zero length: yes

  • Thread starter Thread starter Ronald
  • Start date Start date
R

Ronald

Hi!

I want to create a table by query using the 'CREATE TABLE'-statement. In
there I have a few fields that will contain TEXT. But, I want the 'Allow
zero length' property be set to 'Yes'. How can I do this using a query?

Regards,

Ronald
 
TEXT fields in a CREATE TABLE default to Allow Zero Length.

You need to use DAO or ADOX if you want to change the property to No.
 
Back
Top