using '.' in Combo value list

[ngreenleaf]

I have created a combo box that has "New..." as one of the list items. I want this so that when the user selects "New..." a different form will pop up to gather the appropriate information pertaining to the new entry. I have found that while I can get "New..." to appear on my list - whenever I click on it I get a message that it is not in my list. When I change it to be "New" without the "...", everything works fine.

Is there a way to escape the periods so that they are not interpreted incorectly?

 

[sathandle]

Try changing "New..." to "New" & "..."

Is your code that runs in AfterUpdate looking at the value for "New..." - Try changing that to "New" & "..." as well.

Good Luck!

SAThandle definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."

 

[ngreenleaf]

Using concatenation as described above does not work. I happened to run across a solution completely by accident though. Using "New. . ." works whereas "New..." does not. The spaces take care of the problem and it doesn't appear to be spaced out on the screen. While I do not understand this solution - it works. Also, "New." and "New.." work - but three, four or more periods fail.