Listbox Question

Hi Masters,


Is there a way to make part of the item in the listbox invisible?

I have a listbox containing first name and last name "John,Smith". The question is how to make "Smith" invisible, and that gose for all last names in the listbox.

Remember, Just invisible only not delete it or anything lake that. Because I'd like to be able to write both names(first and last)in to table(this part I know how to do).


Thank you Masters.

Create a second ListBox for the form and set its Visible property to False. Then store only the first name in the original ListBox and store the last name in the new ListBox. You will then need to do things to synchronize the two listboxes like adding code to the Click event of List1 that says

List2.ListIndex = List1.ListIndex