title: Access Alter Table "Allow Zero Length"
body: <p>I'm working with an old Access database (yes, it's very ugly and I hate it).  I need to modify some of the columns from a VB app that I'm creating.  I have most the modifications setup correctly, but I'm fighting with the fact that modifying a column to text has it default to "Allow Zero Length" to false.</p>
  
  <p>SO 
  ALTER TABLE [Applicant Table] ALTER COLUMN [Applicant ID] Text(255)</p>
  
  <p>I need that alter to have "Allow Zero Length" set to true.</p>
  
  <p>I have tried
  ALTER TABLE [Applicant Table] ALTER COLUMN [Applicant ID] Text(255) NULL</p>
  
  <p>but that doesn't seem to work either.  I've looked all over for the solution, but can't seem to find a straight answer.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks,
  Ryan.</p>
  
  <hr>
  
  <p>Thanks for the info.  I'm glad that it's Access and not me.</p>
  
  <p>I guess I'm just going to hack my way through this application since the entire data model is trash anyway.</p>