Divide row between two listboxes

Peter
I'm currently playing with the world of options on the Flex Grid Control.
Fascinating--I never knew this existed. It solves various problems for me. I
currently have more than sixty forms and many switchboards, I've been trying
to find a way to colour some rows, etc., etc.

Thank you.

Peter S.

"Peter Hibbs" wrote:

Peter,

If you need to display records horizontally rather than vertically
then a Flex Grid Control will probably do the job but you will need to
write a bit of VBA code. Have a look at my Flex Grid Demo program for
some examples including one that does what you want.

http://www.rogersaccesslibrary.com/f...22 893c7a6f24

HTH

Peter Hibbs.

Thanks Karl
Sorry I didn't answer your question. The order is solely alphabetical and
there's not anything else to determine the order. I went with John's
solution, but for self education, I'm currently playing with a query that
pulls the fields twice as per your idea. Different ways of looking at the
same problem.

Peter

"KARL DEWEY" wrote:

Was john's depiction of data display what you are wanting?

You did not answer -- Is there any thing else in the records to determine
1st and 2nd?

You can put the table in the query design grid twice (Access adds a sufix to
the 2nd instance of '_1' to distinguish them.

If there any thing else in the records to determine 1st and 2nd then you can
pull 1st record from first table and 2nd record from the second table.

It takes a little jocking so as not to have Cartesian effect.

--
Build a little, test a little.


"Peter Stone" wrote:

Obviously John Vinson is also an MVP in Geography.

Two lists is acceptable if they are even lengths. How do I split them please?

FYI:the form doesn't look like a conventional form. The various list boxes
have the same background as the form and are locked so they can't be clicked.
My goal is to make the information attractive and readable.

P.S. I'm in Antigua but a different one than you're thinking of.
"John W. Vinson" wrote:

On Fri, 18 Sep 2009 15:50:12 -0700, Peter Stone
wrote:

The information is easier to analyze if users can see all rows at once. This
can be achieved by displaying alternate rows in side-by-side list boxes.

I'm not sure I understand. How is it useful to have two interleaved lists,

Antigua Argentina
Bahamas Barbados
Belize Bermuda
Bolivia Brazil

rather than (if you really hate scrolling) two lists, Antigua through Jamaica
and Mexico through Venezuela?

It makes the queries much more complex.
--

John W. Vinson [MVP]