Default Table Value

[xRoachx]

Access 2000:

How do you get the default value of a column in a table
using VBA? Thanks.

 

[Allen Browne]

Try:
CurrentDb().TableDefs("MyTable").Fields("MyField").DefaultValue