Thanks for you reply. The concat I use is in the list box not in the load script.
My Table is
LOAD * Inline
'Dup1: Supplier Name', VendorNameCount
'Dup2: Supplier Name, Address Line 1, Post Code', VendorNameAddress1PostCodeCount
'Dup3: Address Line 1, Post Code', Address1PostCodeCount
'Dup4: Post Code', PostCodeCount
In the List Box Properties > Constraints > Listed Values:
In my Document Support Information:
ListSep Doc=","(2C) Sys=","(2C)
Listboxes don't show values comma separated (or using any other separator). Inputboxes do. You may find this idea and the post I mention within helpful.
So are the values showing as one string comma separated or does the drop down work now?
I think Eric wanted to write Inputbox but he wrote Listbox. Anyways.
Have a look at the below post where Miguel had given the solution.
Hi Miguel and Kaushik,
Thanks for your suggestions. I have changed the registry entry to Computer > HKEY_CURRENT_USER > International > sList = ";" and reboot my computer.
The Document Support Information is now as follows:
ListSep Doc=","(2C) Sys=";"(3B)
Change the input box properties
Unfortunately, the input box is still not quite work.
The test we did in that post led us to the conclusion that the separator that works is the Doc one, not the Sys one. Meaning that if your Doc (local) sep is "," and mine is ";" I still will see your document fine, and viceversa, but when I create a new document, using "," will not work. So set the sList value to "," (or any other value) and make sure that the Control Panel is reading that info (in Windows 7 go to Control Panel, Regional and Language, Advanced, Number tab, Lists separator, and make sure that the dropdown selects the one you want to use.
Then using Concat() with that separator should work if that doesn't conflict with some other separator (in my case, Spanish list separator is ";" because the decimal separator is "," and might lead to confusion.
Hope that helps.