Applecore Pages on Microsoft Access

Changing Field Names in Code

Whilst certain operations to fields do require the creation of a new field with the correct property, inserting the data, and then dropping the original field (for example to change the datatype), but fortunately changing the name is simpler:

CurrentDb.TableDefs("tblName").Fields("OldFieldName").Name="NewFieldName"

Top

 


HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES
E-MAIL
Copyright & Disclaimer

 

Last modified at 06/06/2006 15:01:39