Alphabetical Problems on a Data Access Page

B

bgarey

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
 
B

bgarey

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...
 
B

bgarey

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

Mail Merge Directory Conditional Page Break 0
Space at end of multi page list to accommodate new entries 1
list or combo box 0
Sorting personal templates alphabetically in Office 365 for mac OS? 3
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Enhanced paragraph sort - is it possible? 0
excel 2011 won't sort alphabetically 7

Top