I have two fields. Both are dialog lists using a formula for it’s choices. Both use @GetProfileField to pull a list of values from a keyword field in the profile. One field is giving me headaches, while the other is fine. They both should be doing the same thing …
The list in the profile field is something like …
Chicago
Boston
New York
Richmond
In the bad field, if I select “New York” from the dialog list, “New York” is added to the field. If I click on the dialog button again, the list changes to …
Chicago
Boston
New York
Richmond
New
York
It seems it is treating the space as a separator, but I don’t know why?? The other field looks fine, and they are designed the same. This is an issue as users somehow are ending up with “New” or “York”. It seems like something might be cached, but what and where? It could be some sort of corruption, but what could it be?
Xie Xie
Subject: Space in string acting as separator in dialog list
Is that bad field allows multiple values?. If so, check whether ‘Sapce’ is in option for Multi Value Options under Advanced tab of that field properties.
HTH
Adi
Subject: RE: Space in string acting as separator in dialog list
thank you for your reply…
this seems to be a bug and here is the fix that worked for me…
http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/8bda8de559a9bf0685256de80055fb45?OpenDocument
again, thanks very much for the help!!
Subject: RE: Space in string acting as separator in dialog list
Did you check to see what separators had been specified in the field properties? Maybe space is one of them.
There’s a known issue that a keyword field can get into a state where it treats a space as separator. If the field is not set to multivalue, set it to multivalue. Then go to the Advanced tab of the field properties, select comma as the separator (change the value at least once and leave it as comma to finish), then go back to the first tab and change it back to single-value (if you wish).