View Single Post
  #1 (permalink)  
Old April 16th, 2008, 12:47 PM
bjcountry bjcountry is offline
Registered User
 
Join Date: Mar 2008
Location: , , .
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
Default populating a listbox with a field contains comma

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?