Choosing value list option in a function

[BikeBoy]

Hi,

I can not remember for the life of me what is the function to choose a specific value list entry. For example, I have long entries, and don't feel like typing the whole entry in calculation field:

MyValueList entries:

1. This one is pretty long

2. This one is even longer

SomeField is formatted for the above value List.

CalcField:

Case(SomeField(Function(MyValueList, 1), do something,

Function(MyValueList, 2), do something else,...blah blah.

I think I remember there's a function like that, but can't recall which one:)

Thanks in advance

[ernst]

I think you refer to something like:

Case (PatternCount (ValueListItems (dbname, valuelist), "My first valuelist entry") > 0 , "My first result, .............

Regards,

Ernst