How Can I Display Multiple Rows and Columns?

[Chuck]

Part of my Access 2007 application deals with areas that are defined by ZIP
codes, with each area including one to fifty or more ZIP codes. I would like
to make it easy for users to view as many ZIP codes as possible without
having to scroll in either direction.

For example, one area has already been defined with 42 ZIP codes. It has a
table entry that names the area and gives a general description. A ZIP code
sub-table has 42 entries for that area with one ZIP code in each entry. I
would like to be able to display as many of those ZIP codes as possible on
one screen.

Is there any way to do this? (The DB design is not cast in concrete if
there is a better way.)

 

[Arvin Meyer MVP]

You can display 1 field's data in a single column in a form. That's it. I
understand that you want multiple columns, but that is only possible in a
report.

 

[Chuck]

I was afraid that would be the case. I need another small sub-form to list
people associated with each area. That will need only one to maybe five
entries per area. Maybe I can design the area form with two sub-forms
side-by-side to utilize screen width.

Thanks anyway, Arvin.

 

[Peter Hibbs]

Chuck,

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.