Or if you mean the sequence of fields as you tab through them, look at
the overall Tab Order, or check the Tab Index property of individual
controls.
Access may seem difficult at first, because it is an application
development environment that is very powerful and flexible. You may
want to look at some of the free templates to get you started.
you can drag and drop them in the design view, or in the datasheet view. As
the column order or row order isn't important for the database design, you
can reorder them in any view. Remark that the column order in the design
view (= view on the table object) can be different from the column order in
the datasheet view( = view on the recordset object).
You haven't said if you want to change the sequence in a table, a query,
a form or a report.
If it's a table, don't bother. The important thing about tables is the
content and the relationships between tables, not the layout, as users
shouldn't normally be viewing tables directly - that's what forms and
reports are for.
In Access, data exists in structures (tables / table structure ) which are
independent of documents/views/printed things etc. This is the exact
opposite of Excell or tables in Word, and so those concepts in Word/Ecsel
are misconceptions if you try to use them in Access. So, when it comes to
the above issues, leave anything you learned in Word/Excel behind or you'll
unnecessarily make your job even tougher.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.