Prev: fLoadPicture only for runtime version and problems printing
Next: Cangrow/Canshrink in Lebans RTF control
From: Kitchen on 25 Sep 2006 16:20
I have a lot of fields in a Db and need to be able to print each record with
about 60 fields out on one page. Is there anyway I can use tab windows to be
able to view it all on one page or is there anotherway to have mutiple layers
to a report or am I just out of luck and going to be forced to have 5
different reports.
From: Larry Linson on 25 Sep 2006 16:32
"Kitchen" wrote

> I have a lot of fields in a Db and need to be
> able to print each record with about 60 fields
> out on one page.

I often have far more than 60 fields displayed on a single page of a report,
even though I rarely have "a lot of fields" in a single table. If your
fields are sufficientlly long that they will not fit on a single page at the
smallest font size, then you do have a problem.

> Is there anyway I can use tab windows to be
> able to view it all on one page or is there
> anotherway to have mutiple layers to a report
> or am I just out of luck and going to be forced
> to have 5 different reports.

As I think of _reports_ as printed, hard copy information, it puzzles me how
one would be able to use a tabbed interface to view the information.
Reports, through Access 2003, are not interactive, even when previewed
on-screen.

If you want to view the information on-screen on a single screen, a Tab
Control may be a good approach... using a Form, not a Report. Then, if you
want the information in hard copy, create a report that shows the
information in the least space that you can.

If I have misunderstood your question, please post back and clarify.

Larry Linson
Microsoft Access MVP


From: Duane Hookom on 25 Sep 2006 16:33
Reports are not interactive so a tab control would be useless. Generally, if
you can get your design on paper, you can display it in a report.
60 fields is a lot compared with any application that I have ever created.
--
Duane Hookom
MS Access MVP

"Kitchen" <Kitchen(a)discussions.microsoft.com> wrote in message
news:84BB572A-27EA-409B-B1E7-11112E9AC11B(a)microsoft.com...
>I have a lot of fields in a Db and need to be able to print each record
>with
> about 60 fields out on one page. Is there anyway I can use tab windows to
> be
> able to view it all on one page or is there anotherway to have mutiple
> layers
> to a report or am I just out of luck and going to be forced to have 5
> different reports.


From: Rick Brandt on 25 Sep 2006 16:46
Kitchen wrote:
> I have a lot of fields in a Db and need to be able to print each
> record with about 60 fields out on one page. Is there anyway I can
> use tab windows to be able to view it all on one page or is there
> anotherway to have mutiple layers to a report or am I just out of
> luck and going to be forced to have 5 different reports.

60 fields might too many for the report *wizard*, but not for reports in
general. Just build the report without using the wizard or use the wizard
for as many fields as it will accept and then add the remaining fields
yourself.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


From: Kitchen on 25 Sep 2006 16:47


"Larry Linson" wrote:

> "Kitchen" wrote
>
> > I have a lot of fields in a Db and need to be
> > able to print each record with about 60 fields
> > out on one page.
>
> I often have far more than 60 fields displayed on a single page of a report,
> even though I rarely have "a lot of fields" in a single table. If your
> fields are sufficientlly long that they will not fit on a single page at the
> smallest font size, then you do have a problem.
>
> > Is there anyway I can use tab windows to be
> > able to view it all on one page or is there
> > anotherway to have mutiple layers to a report
> > or am I just out of luck and going to be forced
> > to have 5 different reports.
>
> As I think of _reports_ as printed, hard copy information, it puzzles me how
> one would be able to use a tabbed interface to view the information.
> Reports, through Access 2003, are not interactive, even when previewed
> on-screen.
>
> If you want to view the information on-screen on a single screen, a Tab
> Control may be a good approach... using a Form, not a Report. Then, if you
> want the information in hard copy, create a report that shows the
> information in the least space that you can.
>
> If I have misunderstood your question, please post back and clarify.
>
> Larry Linson
> Microsoft Access MVP
>
>
>

If not in a report, i assume you can do it in a page? Thank you for the
information as well.
 |  Next  |  Last
Pages: 1 2
Prev: fLoadPicture only for runtime version and problems printing
Next: Cangrow/Canshrink in Lebans RTF control