Alphabetical Problems on a Data Access Page

G

Guest

I have a drop down list on a data access page. I want the display list to be
in alphabetical order. The list is in order of the bound column. How can I
get it to change so that the display list will be in alphabetical order.
 
J

John Vinson

I have a drop down list on a data access page. I want the display list to be
in alphabetical order. The list is in order of the bound column. How can I
get it to change so that the display list will be in alphabetical order.
Click to expand...

Base it on a Query sorting the records by that field, rather than
directly on the table.

John W. Vinson[MVP]
 
J

Jeff Boyce

If the control is based on a query, you could alter the query to sort on the
alphabetical field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Guest

Thank you, I should have thought of that.
--
BG


Jeff Boyce said:
If the control is based on a query, you could alter the query to sort on the
alphabetical field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
G

Guest

Thank you, I should have thought of that.
--
BG


John Vinson said:
Base it on a Query sorting the records by that field, rather than
directly on the table.

John W. Vinson[MVP]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I sort items in a drop down combo box 3
Alphabetical order 3
Alphabetical Order! 3
How can I change the column order using VBA 5
record sorting 3
Removing numbers (or non alphabetical numbers from a field) 5
Creating a report with calculated fields 3
Trying to alter the order of my legend in a report 1

Top