List Box Formatting

[Bill]

Given a query that has selected but one field from a
table, how, when using that query as the Rowsource
in a List Box, can I get the data to wrap from one
column to the next, rather than have a scroll control
along the side of the box?

Example:

val-1 val-6 val-11
val-2 val-7 val-12
val-3 val-8 val-13
val-4 val-9
val-5 val-10

What I'm trying to accomplish is to have 4 such displays
side-by-side in a popup form such that the user can select
an entry from each of the lists in forming a four-part expression.

Assuming I'm using the appropriate control for this, I can't
seem to find the format property settings that will cause
the data to wrap to the successive columns.

Thanks for any help,
Bill

 

[John Vinson]

Given a query that has selected but one field from a
table, how, when using that query as the Rowsource
in a List Box, can I get the data to wrap from one
column to the next, rather than have a scroll control
along the side of the box?

Example:

val-1 val-6 val-11
val-2 val-7 val-12
val-3 val-8 val-13
val-4 val-9
val-5 val-10

What I'm trying to accomplish is to have 4 such displays
side-by-side in a popup form such that the user can select
an entry from each of the lists in forming a four-part expression.

About the only way I can see doing this is to use four side-by-side
listboxes, based on separate queries so that each returns the desired
subset of records.

John W. Vinson[MVP]

 

[Bill]

Hi John!

I already have 4 List Boxes side-by-side, each containing
words of the same class and each having their own under-
lying tables. It is only in the case of the first List Box that
there are so many words that they won't fit in a single
column without using the scroll bars. So it was that 1st
List Box that I wanted to have at least the 1st column
wrap into a second column. Having explained it this way,
what I'm understanding you to suggest is that I split the
first of the four List Boxes into two (or more) and condition
the query such that any subset will fit into the nominal size
of the List Box without need for scroll bars?

Bill

 

[Guest]

It would be possible to create a multiple column list box to present the data
like you want it to; however, where it falls apart is in determining which
item the user has selected. Selections are identified by row, not by column.

 

[Stephen Lebans]

It's difficult to work with but the native Access Field List control will do
exactly what you want. See:
http://www.lebans.com/vb_listbox.htm
New Version 3 April 23, 2003 - MULTISELECT must be enabled for this version
to function properly.

Special Thanks to Peter Walker!

FieldList.zip is a database containing the FieldList control Access uses in
its Table Analyzer and Performance Analyzer Wizards. This control is created
directly from the ACCWIZ.DLL so no ActiveX registration problems are
incurred. ACCWIZ.DLL is automatically installed with all full installs of
Access.

This a VB like ListBox with:

1) CheckBoxes for each row

2) True Drag and Drop

3) Conditional Formatting for each Row

4) AddItem method
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[John Vinson]

It's difficult to work with but the native Access Field List control will do
exactly what you want. See:
http://www.lebans.com/vb_listbox.htm
New Version 3 April 23, 2003 - MULTISELECT must be enabled for this version
to function properly.

Thanks Stephen. I should have just sent Bill to your site in the first
place - "If an Access user-interface problem seems impossible,
Stephen's probably done it!"

John W. Vinson[MVP]

 

[Bill]

Thank you Stephen. As Vinson already posted: "If an
Access user-interface problem seems impossible,
Stephen's probably done it!"

Thanks again,
Bill