Combo Box Sort Order

Resolved · Low Priority · Version 2003

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

Phil has attended:
Access Introduction course
Access Intermediate course
SharePoint End User Introduction course

Combo Box Sort Order

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

Sun 5 Jul 2009, 21:49 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips