|  | Sorting a Value List | | |
| | | Gator |  |
|  Posted: Tue Sep 02, 2008 12:30 pm Post subject: Sorting a Value List |  |
In table design, I created a value list as a field's rowsource and I entered
the values through the wizard and the values are now displayed in the format
section in table design with quotation marks around each one and a semi-colon
seperating each one.
My question is how is the best way to sort these values in ascending order
without having to retype each one? Or do I just need to redo the rowsource
as a field list from a table?
thanks |
| |
| | | Al Campagna | |
| | Posted: Tue Sep 02, 2008 1:20 pm Post subject: Re: Sorting a Value List | |
| |  | |
Gator,
I don't believe a value list can be "sorted." I've always enetered them
manually, in alphabetical order, when needed.
But... it's probably best to use a sorted query as the rowsource, based
on the values already in your main table, or from a table of just those
values.
Generally speaking... with a value list, whenever another value arises
in the future, the value list needs to be manually updated. The query
method would only require that the new value be entered against any record,
or... added to your table of values.
--
hth
Al Campagna
Microsoft Access MVP
LINK
"Find a job that you love... and you'll never work a day in your life."
"Gator" <Gator@discussions.microsoft.com> wrote in message
news:8A8959C0-0F1C-40AE-B814-8C9519404A3B@microsoft.com...
| Quote: | In table design, I created a value list as a field's rowsource and I
entered
the values through the wizard and the values are now displayed in the
format
section in table design with quotation marks around each one and a
semi-colon
seperating each one.
My question is how is the best way to sort these values in ascending order
without having to retype each one? Or do I just need to redo the
rowsource
as a field list from a table?
thanks |
|
| |
| | | Klatuu | |
| | Posted: Tue Sep 02, 2008 2:06 pm Post subject: RE: Sorting a Value List | |
Al is correct. A Value List row source for a combo or list box is not sorted.
You can sort it, but I would agree with Al that the user of a table for a
combo row source as always a better idea.
--
Dave Hargis, Microsoft Access MVP
"Gator" wrote:
| Quote: | In table design, I created a value list as a field's rowsource and I entered
the values through the wizard and the values are now displayed in the format
section in table design with quotation marks around each one and a semi-colon
seperating each one.
My question is how is the best way to sort these values in ascending order
without having to retype each one? Or do I just need to redo the rowsource
as a field list from a table?
thanks |
|
| |
|
|
