separators in listboxes using "value list"
I am trying to populate a three-column listbox in Access 2000 by setting the RowSourceType property to "value list" and creating a variable that extracts the values for the listbox from a query. Unfortunately, some of the underlying data includes commas. All the help topics I've found in Access and VBA indicate only the semicolon should act as a separator, but the comma is acting as a separator too. Can I change any property or option in my project, form or listbox to make Access read only semicolins as separators?
|