Combo Box listing problem

[rizunb]

Hi People
How are you doin
Ok I am using access and I have this combo box which is displaying some strings. Now I have actually written some sql that extracts records from the database and then shows them in the combo box

here is the code

Do Until rst.EOF
fillproj = fillproj & Trim(rst("projectName&quot) & ";"
rst.MoveNext
Loop
cbo_proj.RowSourceType = "value list"
cbo_proj.RowSource = fillproj

Now problem is that one record is like "agencies,meetings"
Now when it comes to display this it splits it in 2 rows
like agencies in 1 row and meeting in second row in the combo box. OfCourse it is doing this because of the comma sign. Now I have no idea how to get this fixed.

I hope you people undertand my problem
Thanks in advance
Rizzzzzzzz

 

[gnt]

Can you use the Replace() function to get replace the comma with something else? Or do you need the comma in there?