1 page reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
Click to expand...

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
 
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.
 
Kitchen said:
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.
Click to expand...

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.
 
Larry Linson said:
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.


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
Click to expand...

If not in a report, i assume you can do it in a page? Thank you for the
information as well.
 
If not in a report, i assume you can do it in
a page?
Click to expand...

I don't understand what you are asking. Do _what_ on _what kind_ of page?

Anything I do on a _printed_ page is done with the Report feature, because I
don't think Forms print very well, and I've found no compelling reason to
use the "Printer object."

And, surely it is obvious that an interactive Tab Control can't be used on
any printed material, Report or other. You can use an interactive Tab
Control in a "Form" (screen).

But, if you mean, "Can you place 60 controls in one Detail Section which can
be printed on a single printed page?" Then the answer would be, "Yes, you
can, or, no, you cannot, depending on the amount of information (text) to
be printed in those controls." A large text box to print a nearly-full Memo
field might take more than a page for just that one control.

Larry Linson
Microsoft Access MVP
 
Back
Top