I am populating a listbox on a form. The listbox is unbound. I am populating it via VBA and a recordset based on an SQL statement. It is working fine except for the fact that the field I am using contains a legal name which looks like this LastName, FirstName. I need to have the entire value populate the listbox and right now it is simply cutting off after the LastName.

I also have it set to Debug.Print and the entire name is showing in immediate window so I know it is working properly. How do I get around the issue with the comma?

Does your recordset pull firstname and lastname separately from the db? If so:
Listbox.additem !lastname & "," & !firstname

did that help?

Dartcoach

dartcoach

Just for future reference and if anyone is experiencing the same problem... after some research I found the following solution:

I set the list box with the following statement,

Me.lstLandowner.AddItem Chr(34) & strLandowner & Chr(34)

Once I did this it worked fabulous!

Thank you so much for this! Saved me and may have won me a day off!