multi column list

[Guest]

I would like to display a large number of values in a list box. To do this I
would need it to format the list so it displays more than one column.
Something like the List view in Windows Explorer.

The 'number of columns' control seems to only allow for more than one field
to display, so that doesn't help.

Anyone know of a way to do this?

Access '03, but considering going to '07.

 

[Douglas J. Steele]

The Access list box can't do that.

 

[Guest]

OK; thanks for confirming that.


Anyone ever heard of any way at all to do this in Access 03 or 07?

 

[Guest]

Why not use a datasheet subform to make your list ?

 

[Guest]

The list I would like to display typically has about 120 four-digit numbers.
I'd like to get that list on a form without the users having to scroll. I'm
open to any way to do this, but I don't think a datasheet fits the bill.

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want if you are prepared
to write a bit of VBA code . Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Guest]

Thanks; that's a cool set of tools, but it's beyond my level.

I just figured out a 'pseudo' way to do what I want using four list boxes &
combinations of queries with the Top Values Percantage feature populating
them.