Change Field Order in Table by Code 1

[Pampers]

Hi Everyone,
I have a little form with a button to modify/create tables and field in a back end of database. I have some code to add a field to a table. That works fine except that it adds this new field always on the bottom. Can I influence were the field is placed within the field-collection the table?



Pampers
Keeping it simple can be complicated

 

[PHV]

Who cares the place of a field in a table ????
Always use a query to display the data in any column order you want.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pampers]

Eh, I...
I Like to have the field names in the table grouped i certain way

Pampers
Keeping it simple can be complicated

 

[PHV]

Have a look at the OrdinalPosition property of the DAO.Field object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pampers]

Will do, thanx PHV

Pampers
Keeping it simple can be complicated

 

[Pampers]

Yep, works.

Example:

tdf.Fields("test").OrdinalPosition = 0

Pampers
Keeping it simple can be complicated