Table Design view question

  • Thread starter Thread starter Dar
  • Start date Start date
D

Dar

In design view of a table, I have 50 fields. Is it possible to sort the
names of the fields alphbetically automatically without having to manually
sort them?
 
If you mean you want to reorganize the fields in the table so they are in
alpha order, then the simplest thing is to do it manually.

Do you just want to display an alphabetic list of the field names? IF so,
where do you want to do this? On a form, in a listbox or combobox, in a report?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
?50 fields?

It is fairly uncommon to find a well-normalized relational database table
with even as many as 30 fields.

If your table has 50, it might benefit from further normalization.

If you'll post a description of those fields and an example of the kinds of
data stored therein, folks here may be able to offer suggestions that will
let you make better use of Access' relationally-oriented features/functions
(and will save both you and Access a lot of work on work-arounds).

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Because I need to find a field and it would be easier if they were
alphabetised.
So, can it be done?
 
Try opening table in design view and draging the fields in alpha order and
then save.
 
Back
Top