put dropdown list in alphabetical order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within Access 2000, I have created a form with a dropdown menu, how do I make
it show this dropdown menu in alphabetical order?
Please someone help
 
Hello there,

You need to create a query on the field required and
choose Ascending in the Sort row.

Then right click on the dropdown and choose Properties.
Click the dropdown arrow in the Row Source and choose the
query you have just created.

I hope this helps

Judith
 
Within Access 2000, I have created a form with a dropdown menu, how do I make
it show this dropdown menu in alphabetical order?
Please someone help
Click to expand...

Use a Table/Query as the row source type, and base the combo on a
Query sorting the fields however you wish.

If you're using a Value List, you need to manually sort the entries.
Access won't do it for you.


John W. Vinson[MVP]
 
Back
Top