I've searched around some for an answer but I've had no luck.

I have a value list that has about 5 choices. How can I make the values appear in a specific order when viewing it as a simple text in field.

I'd like the values to show up in a certain sequence no matter what order they were clicked to start with.

Hi

Your question isn't so clear ( at least for me ! )

Do you wish to have a text field that displays the second value in the second row ?

sorry for the confusion.

So in a questionnaire there is a set of checkboxes, with 5 values (Item 1, Item 2, Item3, etc...). Each person can choose all five or none of the checkboxes.

In a related layout we only view that field as a text field. So if someone chooses Items 2, and Item 3. Those values show up as text. What I want to do is make sure they appear a logical order. Currently they appear in whatever order someone clicks chooses them. So when viewing it as text we might see;

Item2

Item5

Item1

Item4

I want to force it to show as;

Item1

Item2

Item4

Item5

when viewed as text.

Does that help?

If so, you need a calculation text field ( or a text field with AutoEnter option ) and calc:

FilterValues ( ValueListItems ( Get ( FileName ) ; "YourList" ) ; list )

where "list" is your field formatted as a check box set.

Edited August 27, 200718 yr by Guest
edit in order to answer to your precisation