Sorting a Value List

[Gator]

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]

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
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Klatuu]

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.