ReNaming a table's field name with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it pretty simple to rename the field [businessphone] in table [tbcontacts]
to a different name?
thanks,
charlie (CK)
 
Yup, it's pretty simple.

Using DAO, it would be:

CurrentDb().TableDefs("tbcontacts").Fields("businessphone").Name =
"busphone"
 
Back
Top