Methinks that for so many columns, you should consider using a grid instead of a ListBox.
>Dear Sir,
>
>I want to get your help
>
>I have a listbox that contains six columns
>The leftmost three columns are character fields and others three are numeric
>type.
>
>I want to show numeric fields, in listbox, as following format
>
>99,99,999.99
>
>Which rowsource and rowsource type should I use?
>
>Please help with some examples.
>
>Thanking you in advance
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)