Re: How to arrange values in combo box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PC Datasheet (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 Datasheet
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdatasheet.com
                                 www.pcdatasheet.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]

Relevant Pages

  • Re: Sorting Problem, please help
    ... you don't need to loop to reorder the lines -- ... several lines of code with numbers and letters. ... original file and sorts those lines by the numbers. ... with 106 characters (including spaces and the carriage return at the ...
    (comp.soft-sys.matlab)
  • Re: combinations listing
    ... It splits every letter of one word, sorts the letters and joins them ... now for acb: ... Hope you see how the hash is built. ...
    (comp.lang.ruby)
  • Re: Sorting Problem, please help
    ... so i have been mostly teaching myself. ... several lines of code with numbers and letters. ... original file and sorts those lines by the numbers. ...
    (comp.soft-sys.matlab)
  • Re: What does l33t mean?
    ... online for awhile called "leet-speak" that involved ... using numbers for letters and other sorts of geeky ...
    (alt.games.warcraft)