Re: How to arrange values in combo box

From: PC Data*** (nospam_at_nospam.spam)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 00:14:10 GMT

Or ----------

Use All like this: <All>

The "<" sorts before any letters or numbers in the other records. 

--
                                        PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"Marshall Barton" <marshbarton@wowway.com> wrote in message
news:0on3t0hnb0odj2immgig2qc4ncmqrkr3an@4ax.com...
> Jack wrote:
> >I have a combo box where it lists a single field recordset. However, this
> >recordset has a value all. Is there any way to display ALL first and then
> >display rest of the records in a ascending manner? In other words ALL
should
> >be at the top and should not be affected by the ordering of other
records.
>
>
> If the recordset comes from a table, just change the ALL
> record to put a space in front of it.  A space will sort
> before any letters or numbers in the other revords.
>
> --
> Marsh
> MVP [MS Access]