<div>
is it code is correct<br />

<pre><code id="code-196158">ALTER TABLE tblGLBudgetBalance ALTER COLUMN  intFiscalYear NUMERIC  ADD  DEFAULT WITH ( 0)
</code></pre>
</div>


is it code is correct


ALTER TABLE tblGLBudgetBalance ALTER COLUMN  intFiscalYear NUMERIC  ADD  DEFAULT WITH ( 0)


<div>
try this<br />
<br />
ALTER TABLE tblGLBudgetBalance ALTER COLUMN &nbsp;intFiscalYear NUMERIC &nbsp;DEFAULT 0
</div>


try this

ALTER TABLE tblGLBudgetBalance ALTER COLUMN  intFiscalYear NUMERIC  DEFAULT 0

<div>
you have to do it in two steps<br />
<br />
sub changeCol()<br />
CurrentDb.Execute _<br />
&quot;Alter tblGLBudgetBalance ALTER COLUMN &nbsp;intFiscalYear number&quot;<br />
&nbsp; &nbsp; Dim dbs As Database<br />
&nbsp; &nbsp; Dim fld As DAO.Field<br />
&nbsp; &nbsp; Set dbs = CurrentDb<br />
&nbsp; &nbsp; Set fld = dbs.TableDefs(&quot;tblGLBudget<wbr />Balance&quot;).<wbr />Fields(&quot;in<wbr />tFiscalYea<wbr />r&quot;) <br />
&nbsp; &nbsp; fld.DefaultValue = 0<br />
end sub
</div>


you have to do it in two steps

sub changeCol()
CurrentDb.Execute _
"Alter tblGLBudgetBalance ALTER COLUMN  intFiscalYear number"
    Dim dbs As Database
    Dim fld As DAO.Field
    Set dbs = CurrentDb
    Set fld = dbs.TableDefs("tblGLBudgetBalance").Fields("intFiscalYear")
    fld.DefaultValue = 0
end sub

<div>
<div class="content wysiwyg-content">
Following code is Correct or incorrect? if incorrect then what is correct code<br />

<pre><code id="code-196155">ALTER TABLE tblGLBudgetBalance ALTER COLUMN  intFiscalYear NUMERIC  ADD  DEFAULT WITH ( 0)</code></pre>
</div>
</div>


Following code is Correct or incorrect? if incorrect then what is correct code

'ALTER TABLE tblGLBudgetBalance ALTER COLUMN  intFiscalYear NUMERIC  ADD  DEFAULT WITH ( 0)'  What syntax wrong in statement for MS-Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.