Value List in Custom Dialogue

[Genx]

Quick question,

I'm trying to put a value list into a custom dialogue for display... and comma seperate it etc with no luck... i.e.

Let (valueDisplay = Substitute(ValueListItems(Get(FileName);"ValueListName") ; ; ", ") ;

Left(valueDisplay ; Length(valueDisplay) - 2))

Yes i am sure i am using a real value list and it's name is correct. Thanks for any suggestions.

~Genx

[LaRetta]

Substitute(ValueListItems(Get(FileName);"ValueListName") ; ¶ ; ", ")

But for goodness sakes, it doesn't work with Value Lists! It worked in vs. 6! And it works with Get(RecordNumber) etc... It doesn't work in vs. 7.0v3 or 8.0v2.

Edited March 22, 2006 by Guest

[LaRetta]

Alright. I feel insane. I swear it didn't work and now it does ... both in 7.0v3 and 8.0v2. I must be overdue for a long break ...

[Genx]

Lol, yeh, mine was just to trim the last comma off... Cause it looks ugly, but it doesn't change the fact that i can't get my list into my dialogue box :

[LaRetta]

Emmm, Value Lists clean up their own ¶ and it doesn't end up with trailing ',' at all. See attached. If it still isn't working, then we'd need to see your file. It displays in all three places - Title, message, and input message.

CustomDialogVL.zip

[Genx]

Sorry, i was getting my value list formatting confused with user added values... where a user adds value x and a carriage return to a field... sorry. Thanks for the file, maybe i got my syntax wrong or something, ill have a look.

Cheers,

~Genx

[Genx]

Lol, yeh it works, but for some reason i can not remember the script i needed it for originally... and out of my 300 scripts nothing rings a bell!!! I am so distraught right now. But thanks for the help LaRetta.

~Genx