How to divide data of a listbox to 2 column?

[viccop]

Hi everybody,
My simple question is... how to divide the data of a listbox to 2 columns, but note that the list box get data from 1 field, not 2 field. For example, my all record is from A to Z. If default, it will display in the listbox from A to Z in one column, but i want divide display in the first column is from A to H and the second column from H to Z..



Thanks in advance!

 

[Ron_dK]

I would suggest making two listboxes.

Base listbox one on a query , something like this :
SELECT Table1.Field1
FROM Table1
WHERE (((Table1.Field1)<="h*"))
ORDER BY Table1.Field1;

and another query for listbox 2 like :

SELECT Table1.Field1
FROM Table1
WHERE (((Table1.Field1)>"h*"))
ORDER BY Table1.Field1;


Hth

 

[boblarson]

Native listboxes do not have the ability to do this, so Ron_DK's suggestion is the way you would need to go.

 

[viccop]

yes, i see. Thanks for your helps!