I recently learned how to set default values for all fields in a table using VB (DAO).
Public Sub Make_defs()
Dim x As Integer
For x = 1 To CurrentDb.TableDefs("import_format").Fields.Count
CurrentDb.TableDefs("import_format").Fields(x - 1).DefaultValue = "=null"
Next
End Sub
I had a...