>Hi,
> I have a list box with a view as row source. I want to show the first column of the view in my List box. But I want to show it in multiple column layout. ie. First 8 values go in first column, next 8 values go in the next column and so on.
>
>I looked at different properties and methods of List box, I couldn't find a way of doing it.
>
>Is there any way of doing it?
>
>I appreciate ur help.
>
>Thanks
>Puri Malluru
Puri,
Not using your current set up. You could change the rowsourcetype to None and populate the list using AddListItem calls in the requery of the lisbox.
SELECT TheCursor
LOCAL lnCol, lnNewItem
lnCol = 1
lnNewItem = 1
THIS.Clear
SCAN
THIS.AddListItem(Alias.Field,lnNewItem, lnCol)
lnNewItem = lnNewItem + 1
IF lnNewItem > 8
lnNewItem = 1
lnCol = lnCol + 1
ENDIF
ENDSCAN
THIIS.ColumnCount = lnCol