<div>
Would it be possible to use DAO for this? &nbsp;It's a lot easier that way. &nbsp;Then after you create the fields in the table, you can select the Field object from the Fields collection of the table and set it's Default property. &nbsp;<br />

</div>


Would it be possible to use DAO for this?  It's a lot easier that way.  Then after you create the fields in the table, you can select the Field object from the Fields collection of the table and set it's Default property.  


<div>
I don't know if DAO would work...could you show me how this could be done?<br />

</div>


I don't know if DAO would work...could you show me how this could be done?


<div>
You should replace &quot;PostalCode&quot; with your fieldName <br />
&nbsp; &nbsp; tdfMyTable.Fields!YourFiel<wbr />dNAmeHere.<wbr />DefaultVal<wbr />ue = 0 ' assume it is a number field<br />
Regards<br />
Dalin<br />

</div>


You should replace "PostalCode" with your fieldName
    tdfMyTable.Fields!YourFieldNAmeHere.DefaultValue = 0 ' assume it is a number field
Regards
Dalin


<div>
<div class="content wysiwyg-content">
Is there any way to set the default value of a field when you use the ALTER TABLE command to create new fields on an Access table? Currently it defaults to null, but I need it to be zero.
</div>
</div>


Is there any way to set the default value of a field when you use the ALTER TABLE command to create new fields on an Access table? Currently it defaults to null, but I need it to be zero.

Default values for Access fields

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.