Continuous Form Grid Control

  • Thread starter Thread starter Jim Franklin
  • Start date Start date
J

Jim Franklin

Hi,

I am trying to find a 3rd party control (or some other means) that allows me
to display records as in a continuous form, but showing records stacked
horizontally and
vertically in a grid, rather than just vertically as the standard continuous
form does. I have a small square form, which I want to fill the screen, e.g.
if there were 20 records, they might appear say in a 5 x 4 grid of squares.

I have looked at various TreeGrid ActiveX controls, but unless I am missing
something, they dont appear to do this. I know it can be done with Borland -
is there no way of doing it in Access?

I am currently using A2K and AXP. Does anyone know where I might find
something like this?

Thanks for any help,
Jim F.
 
Jim,

Couldn't you just count the number of entries, split that number into the
most feasible number of rows and columns, and then use the properties of the
grid control you mention to fill up the grid ? A grid control will surely
have properties like NumRows and NumColumns (or the like) you can set/fetch
?

You could eventually make a wrapper Access class module that would find the
appropriate entry (row, column) indexes based on that single number, as the
number of rows and columns could be known internally to that wrapper class.
Maybe I'm missing something, but this looks to me as being the most
straightforward way ...

Kind regards,

flupp
 
Hi Flupp,

Thanks for the reply. I am not sure exactly what you mean. Can you fit a
'form' into each cell of the grid? Forgive me if I am being thick here!

Effectively I want it to look like a continuous form (not datasheet), but
instead of each record being displayed in a single vertical column have
multiple columns.

I know this can be done in Borland - is it possible using Access?

Jim
 
If you don't use a datasheet view..but use continues form view..then you can
have as many lines of detail for each record you want:



FirstName LastName Addresss
Albert Kallal 123

Or, you can go:

FirstName: Albert 123
LastName Kallal

In other words..each detail line can be two lines if you wish.

Here is some screen shots of grids to give you some ideas.


http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

None of hte above use more then one line for the details..but I could hae...
 
Back
Top