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 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.
 
You could use the existing Microsoft control. Just fill
the grid yourself. You can put whatever you want,
wherever you want in the grid. j.
 
Jim Franklin said:
I am trying to find a 3rd party control (or some other means) that allows me
to display 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.
Click to expand...

One approach might be to simple have 20 fields on the form. Then
loop through the control values yourself and read/write the records to
the table.

Another alternative would be to create a temporary table just before
opening the form with the five fields sideways. If the data already
exists then use some queries to fill the temp table. When the user
closes the form use some queries to write each non null field to a
table.
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?
Click to expand...

Not that I'm aware of but there is a list of Access compatible grid
controls on the third party utilities page at my website. Most of
the grid controls allow you to download a demo version and see if it
suits your needs. I also would strongly suspect that they will have
lots of Access specific code samples.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top