Question on Sorting in Ascending Order the Field Names

[margaret]

I'm a beginner Access user that has just designed via
design mode a new table. The table has about 50 column
headings in it. As I entered the field names in the design
mode, I didn't put them in alpha order, but now I've
realized that'll be very helpful to me in putting in the
raw data!

How do I alphabetize the field names (for about 50
columns) once they're in already?

Thanks.
Margaret

 

[Douglas J. Steele]

There's no automated way, but there's also really no need to worry about it.

You should never be entering data directly into a table: you should always
use a form. Simply arrange the fields however you want on the form. If
necessary, you can create a query that has them in the desired order, and
use that in your form.

 

[John Vinson]

How do I alphabetize the field names (for about 50
columns) once they're in already?

Any table with fifty fields is almost certainly badly designed from a
relational perspective. Are you storing repeated values (such as Jan,
Feb, Mar or Name1, Name2, Name3)? or are there groups of fields that
are mutually dependent, so that if you have a value in one field you
must have another field empty?

You can manually move fields around in the table design grid:
mouseclick the "handle" at the left edge of the fieldname so that the
whole row highlights, and drag it up or down. But there's no easy
automated way to do this.

On the other hand... you should NEVER look at table datasheets in
production anyhow. They are for debugging and design use ONLY. Use a
Form to display and edit your data; on a Form you can put the
textboxes anywhere you like.