It is possible to change the field properties for fields in a table via code?
I would like to change a field from a text box to a combo box. This code below does not work
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Display Control") = "Combo box"
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Row Source Type") = "Table/Query"
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Row Source") = "SELECT [Person].[PersonID], [Person].[FullName] FROM Person;"
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Bound Column") = 1
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Column Count") = 2
db_current.TableDefs("CTTrainingAssgnment").Fields ("8/24/2021").Properties("Column Widths") = "0;1"