Putting one value always on top

[JonAgnew]

I have a value list of vendors based on a field. I have one particular vendor that I want to always be at the top and the rest sorted in alphabetical order. Is there a way to do this?

[LaRetta]

Hi Jon,

About the only thing I can think of is to begin the vendor name (at least the one used in the value list) with an underscore (which will sort before any alpha or numeric character).

If you then base your value list upon values from field ( all values ) and select the VendorID but display vendor name as second field and below specify sort on second field.

ADDED: You can begin the vendor name with space (or dash) also ...

Edited March 24, 2012 by LaRetta