Adding Items to ComboBox with an "&"

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Couldn't find this in a search of the forum.
How do you add items to a CommandBar ComboBox that contain an "&" in the expression (like Johnson & Johnson)?  I've tried a few variations of the following, without success:
sListItem = Replace(sListItem, "&", "' & '")
Thanks!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
DDJJ Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 13 December 2004 Status: Offline Points: 143	Post Options Post Reply Quote DDJJ Report Post Thanks(0) Quote Reply Topic: Adding Items to ComboBox with an "&" Posted: 17 December 2004 at 1:51pm
	Couldn't find this in a search of the forum. How do you add items to a CommandBar ComboBox that contain an "&" in the expression (like Johnson & Johnson)? I've tried a few variations of the following, without success: sListItem = Replace(sListItem, "&", "' & '") Thanks!

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 17 December 2004 at 1:57pm
	I have no problem adding them. You can hard code it and say "Johnson & Johnson" or place that string in a variable then assign it.

DDJJ Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 13 December 2004 Status: Offline Points: 143	Post Options Post Reply Quote DDJJ Report Post Thanks(0) Quote Reply Posted: 17 December 2004 at 2:10pm
	What's happening to me is the ComboBox is showing "Johnson _Johnson". I am retrieving the string from a database field, assigning it to a string variable, then adding it to the combo using the AddItem method. Any kind of an "&" gets converted to an underscore. Same thing when I (for testing purposes) hard code the string variable.

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 17 December 2004 at 2:19pm
	OK, I see, it is displayed OK when dropped down, but when selected it displays the underscore. If you use "&&" if fixes the one problem but displays "&&" in the drop down. I think I remember this being a bug in the report control and it was fixed, so submit this as a bug so the development team can fix it Edited by SuperMario

Oleg Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 May 2003 Location: United States Status: Offline Points: 11234	Post Options Post Reply Quote Oleg Report Post Thanks(0) Quote Reply Posted: 20 December 2004 at 4:39am
	We fixed it. Thank you.
	Oleg, Support Team CODEJOCK SOFTWARE SOLUTIONS