realign column headings

[shank]

I have a table with 20+ columns.
I've gone into design and rearranged the columns.
Flip back to display mode and they didn't update the order I've chosen in
design mode.
How do I get them to update and realign without me doing it manually?

thanks!

 

[Steve]

You're wasting your time fighting with this. Use a query as the recordsource
for your forms and reports and use a query for the rowsource of comboboxes
and listboxes and you can put the fields in any order you wish in the query.

Steve
(e-mail address removed)

 

[John W. Vinson]

I have a table with 20+ columns.
I've gone into design and rearranged the columns.
Flip back to display mode and they didn't update the order I've chosen in
design mode.
How do I get them to update and realign without me doing it manually?

thanks!

There is no benefit to doing so. You (and your users) should never be looking
at table datasheets anyway, and the order of fields in the query does not
affect the creation of queries or much of anything else!

If you really feel that you need to do so you'll need to create a new table
with the fields in the order that you want, and then run an Append query
inserting the data from the old table; rename the tables, reestablish
relationships, and delete the old table. Compact the database when you're done
to recover the wasted space.