Unanswered: Pass a string with commas to a listbox
I'm sure there's a vba function for this, but I can't find it for the life of me.
The application for this is populating a list box. I have a mutli-column list box that is populated based on a string stored in a single field. I have no problems using this method UNLESS the string being passed has a "," . In which case, it creates a new column. Is there a way to explicitly pass the comma as part of the string value for the row?
Since I know my first question would be, "But Teddy, why don't you just make more fields for each possible preference and assign it as the datasource to the listbox." I'll answer to that now.
The primary function of this code is to populate a listbox containing user preferences for any given report. Each report may have a variable number of preferences associated with it. Therefore, each report has a field that contains the names and column widths for the preference listbox, which I split and assign when needed. That's not a problem at all.
Then in the report preferences table, the preference itself is stored as a ";" deliminated string, as there are many, many, many different possible preferences for each different report, and this is the only way to avoid immense bloat.