Drop down list sort order

[Wikisnoodle]

Is there any way to force the sort order of what appears in a drop down list when using values from a field?

eg: Low-Medium-High, not High-Low-Medium (a simple example, others are more complex).

Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values.

I don't want a second item in the list, but I also don't want items in alphabetical order. I want them in the sort order of the records/fields the list is compiled from.

(I'm trying to match what the client currently gets in an Access database. If I can't sort it, they'll just have to do with, what is to them, an illogical order.)

[comment]

Could you explain this part:

Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values.

[Vaughan]

No, value lists based on fields cannot be custom sorted, they are always sorted alphabetically ascending.

Instead use a custom value list.

[randhir]

value list based on fields can not be custom sorted .

[efen]

Another post that just repeats the previous answer and adds nothing more ...

http://fmforums.com/forum/topic/79906-find-matching-records/page__p__371960#entry371960

[Lee Smith]

value list based on fields can not be custom sorted .

Please do not repeat a previous answer without commet.

Lee

[Wikisnoodle]

"Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values."

All users but one, have 'Staff' access (editing-only, locked out of a couple of layouts). I have one other user, call him 'ClientAdmin', he's actually editing-only, but does have access to a couple of extra layouts.

I could only use an editable custom value list, if I could make it non-editable for all users but 'ClientAdmin'. Can I give different custom value list access rights to different accounts?

[Raybaudi]

"I could only use an editable custom value list, if I could make it non-editable for all users but 'ClientAdmin'."

Yes, you can.