Setting Default Value with code

[aziz rasul]

Is it possible to set the default value property for a field in a table using VBA code?

 

[ErikSnoek]

CurrentDb.TableDefs("name_of_your_table").Fields("name_of_the_field").DefaultValue = "Test"

 

[aziz rasul]

Many thanks.