Combo Box Sort Order

The UK's most regular instructor-led training courses.
Training information: microsoft access 2002 training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

2 posts

ReplyThu 2 Jul 2009, 15:56Delegate Phil said...

Phil has attended:
Access Introduction course
Access Intermediate course

Combo Box Sort Order

How do I sort the data in a combo box (eg alphabetically) (ref. Unit 6 excercises)

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

648 posts

ReplySun 5 Jul 2009, 21:49Trainer Simon said...

RE: Combo Box Sort Order

Hi Phil,

Thank you for your question.

When you attach a lookup wizard to a field there is a step in the wizard where you can sort the field in ascending or descending order.

Alternatively, when you create a combo box via the control toolbox, select the field and then choose to sort the data in ascending or descending.

I hope this answers your question.

Regards

Simon

Mon 13 Jul 2009: Automatically marked as resolved.

· So You Want To Create Forms In Access 2007?
· Access Corruption Avoidance Tip #1: Split Your Database
· Making The Transition To Access - Why You Might Need It
· How To Find Good Access Database Courses In London
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips