Alphabetize field names in query design

[ThompsonA]

I have an Access 2000 table with 80+ fields. When fields are selected for a query from this table, the user must scroll through the table to find the desired field. It would be much easier for the user to find the field(s) of interest if the field names were alphabetized in the pick list. Is there a way to alphabetize this list?

Thank you for your help!

 

[bapprill]

If you are using VBA, you can add a line of code similar to:

Forms![Search Results].OrderBy = "FieldName"

at the end of your code, just before the End If statement. ~~ Laziness is the mother of invention ~~