Combobox's list separator character, not separating correctly

  • Thread starter Thread starter Emil
  • Start date Start date
E

Emil

HI,

I have a combobox on a form. I set the rowsource for it in code, to a string
of values delimited with ";" character.
The 'Row Source Type' is set to 'Value List' and 'Separator Characters' is
set to ";" on the form and also i set these properties in code to the same
values (acSeparatorCharactersSemiColon for the Separator Characters).
Anyway on the form, in the list of items for this combobox access, does not
separate them correctly.
For example if I have the string "Company_1;Company_2, INC.;Company_3" the
items in the combobox will be:
Company_1
Company_2
INC.
Company_3
So access is considering the "," also as a delimiter, even if I set the
delimiter only to ";"

How can i fix this?
Thank you.
 
Back
Top