"Therein lies the rub" or something like that.
(with apologies to Shakespere)

I KNOW the other lists are inferior.. No doubt in MY mind, that's why I
participate as much as I do with THIS one.
But, in order to "execute due diligence", I had to attempt a Google search in
order to at least attempt to find it on my own before posting the problem to the
group! But alas, the others seem to be confined to a single solution, no matter
what the circumstances!

The original data set in Oracle has over 700,000 records.
The "filter" fields are used to issue a select statement to retrieve records
from the Oracle database.
Depending on the number of filters, the number of records returned should be
reduced.
But initially, the number of records in the listbox  could exceed the 65536 row
limit.

For instance, the user says indicates that he's only interested in the records
for department #2101.
The Select returns 231,400 records.
Of these, he's only interested in those for product code 046, so the sub-select
returns 121,000 records.
Limiting those records to only those processed in the last 90 days returns
16,000 records.
The user is interested in only those records exceeding $1,000. This returns 300
records.
He may choose to "export" these records to an Excel file for detailed
consideration, print the records, etc...

Now, of course he could enter these fields in any order until his list is
manageble, but he won't know what the minimum requirements are until he begins
entering the filters.

For instance, if he were interested in deparment #2180, the number of records
selected is only 4,000. This may be sufficient for his needs. He can sort the
list numerically and quickly locate the record he's interested in.

So far, in my testing, (on smaller data sets) it's quicker to select the data
from Oracle and clear and refresh the list than it is to create the listbox with
all data and then remove rows based on the selection criteria, but that's not
germaine to the issue at hand.

The listbox seems to function as I wish, except for the headings.



BTW: I've not come across a way to display column  "separators" or Excel-type
column "borders" in the listbox. Is there another term or parameter that I
don't recognize? It sometimes is another "feature" entirely that just happens
to achieve the desired effect.

Also, do you know of a "click" event that relates to the headings in particular?
I'm considering coding sort functions by clicking the column headings and have
the list data sorted by the column values.

(I like creating multi-functional applications, and enjoy it when a user tries
something that makes perfect sense to them and I have anticipated their twisted
sense of potential!)