multi column list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bicyclops - 06 Nov 2007 18:53 GMT

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.

Reply to this Message

Douglas J. Steele - 06 Nov 2007 19:23 GMT

The Access list box can't do that.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I would like to display a large number of values in a list box. To do this
>I
[quoted text clipped - 8 lines]
>
> Access '03, but considering going to '07.

Reply to this Message

bicyclops - 06 Nov 2007 19:36 GMT

OK; thanks for confirming that.

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

> The Access list box can't do that.
>
[quoted text clipped - 10 lines]
> >
> > Access '03, but considering going to '07.

Reply to this Message

BrerGoose - 06 Nov 2007 22:04 GMT

Why not use a datasheet subform to make your list ?

Signature

BrerGoose
Moose-Tech Software:
http://ourworld.compuserve.com/homepages/webspace/MTS/Home.htm

Reply to this Message

bicyclops - 07 Nov 2007 12:46 GMT

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.

> Why not use a datasheet subform to make your list ?

Reply to this Message

Peter Hibbs - 07 Nov 2007 15:37 GMT

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%20Grid%20D
emo.mdb'

for some examples.

Peter Hibbs.

>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.
>
>> Why not use a datasheet subform to make your list ?

Reply to this Message

bicyclops - 07 Nov 2007 16:46 GMT

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.

> 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 -
[quoted text clipped - 10 lines]
> >
> >> Why not use a datasheet subform to make your list ?

Reply to this Message