Continous Subform and Newspaper Columns???

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hi,

I'm not sure exactly how to describe what I want here because I want to use
the word 'column', but in a newspaper sense not field-wise.

I have a subform that is a continuous form. The subform displays 4 fields
of data for each record. The problem is that there may be a respectable
number of records to be viewed. I would like to make life a little easier
for the user by having the subform show the data in columns of columns.
Say, show 20 records and then move over and show the next 20, etc.

Is this possible?

thanx
Sean
 
Sorry, didn't even pick up on the fact that you were talking about Forms and not
Reports. Obviously, my initial response is useless.

I don't believe anything like what you want is possible. Unless it involved multiple
subforms each filtered to pick up only a portion of the total records.
 
There is one way, which would be what Rick said. Create multiple subforms
and have it filtered to show each group of options. However, this may mean
you will have too many or too few columns depending on the amount of data to
show. The only way would be to create the form dynamically each time the
form is opened. This is very complicated but would accomplish what you
want. Let me know if you are up to this type of programming.

Kelvin
 
Thanks,
I had thought of that thinking that I could set the visible property based
on the number of records, but shyed at the idea because my brain is already
hurting today and I didn't want to even try to figure out how I would limit
each subform to a maximum (whatever would be visible or minimize scrolling)
number of records. Fortunately, the data breaks down nicely into a finite
(and small) number of regions, so I think I'll use an option group to filter
per region.

Thanks again
Sean
 
Back
Top