Re: Listbox load question
Quote:
Originally Posted by kfinpgh
The additem function splits the entry at the comma.
It shouldn't, and in fact I just tried it and it didn't. Perhaps there is some other (non visible) data embedded in the string which is causing your problem, eg a linefeed or carriage return etc
Re: Listbox load question
I am using VBA, which may behave differently than VB6. If there were other characters in the field, Access would split the contents of the field in other operations.
Re: Listbox load question
Access VBA question moved to Office Development
Re: [RESOLVED]Listbox load question
I used findandreplace() to change the comma to " and ". I reverse the process when the listbox contents are used in a multi-item selection table. That turns the " and " back into the comma.
Works OK for a small list, but 11 names can take a while.