[RESOLVED] Commas in Combobox problem

[ChrisR873]

Well,
The replace function does work, but not the way you intended it to. I would have to use another character besides a comma in order for it to display. For example a period, but that doesn't look right and I would still prefer displaying a comma. Your idea of replaceing with two commas just makes more rows.

Anyone else have any suggestions on the issue?

EDIT: I ended up solving my own problem. What I ended up doing was utilizing the replace function to replace the comma with another comma. Except it was a different character. To help explain better heres my replacement code.

Do While Not rstORG.EOF
        orgTEXT = (Trim(rstORG!org_desc))
        If InStr(1, (Trim(rstORG!org_desc)), ",") > 0 Then
            orgTEXT = Replace(rstORG!org_desc, ",", Chr(130))
        End If
        cmbOrganization.AddItem (Trim(orgTEXT)) & " (" & rstORG!org_id & ")"
        rstORG.MoveNext
    Loop

What it does is replace the character 44 with character 130. Which are both commas. But because the combobox/listbox takes the character 44 as a row seperater, this is a workaround. Hope this helps anyone out.

Thanks,
~Chris