Setting Table Defaults

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Is there some VB code tha will alter the properties of a table field? For
example, through VB code, I want to make teh following change:

Table: tblAgents
Field: EmployeeAgent (type: true/false)
Default Vale: NULL

Want to change default value to "True"

Would it involve some basic coding of this type:

Set td = db.TableDefs("tblAgents")
td.Fields("EmployeeAgent").DefaultValue = "True"
db.TableDefs("tblAgents").Properties("EmployeeAgent").Value = "True"

Help?
 
Back
Top