put dropdown list in alphabetical order

C

cdjsb

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
 
J

JudithJubilee

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
 
J

John Vinson

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]
 
Top