By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

Print all columns of subform in datasheet view

P: n/a
Hi,

I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.

FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.

TIA,
Brian

Aug 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 3 Aug 2006 12:39:17 -0700, "gh****@gmail.com" <gh****@gmail.com>
wrote:
>Hi,

I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.
Create a Report, with the fields laid out in whatever format you wish.
>FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.
Simply create an ad-hoc query, and base your report on that query.
Does the subform have different FIELDS - not just different data -
based on the query?
John W. Vinson[MVP]
Aug 4 '06 #2

P: n/a
John,

I had tried your suggestion. Unfortunately, MS Access does not allow
reports that are greater than 22 inches in width. My 50 columns need
the report to be atleast twice as wide.

And no, the fields in the sub-form do not change based on the query.
Only the data changes.

Thanks,
Brian

John Vinson wrote:
On 3 Aug 2006 12:39:17 -0700, "gh****@gmail.com" <gh****@gmail.com>
wrote:
Hi,

I am trying to print a subform containing approx 50 columns in
datasheet view. The printout cannot fit more than 8-10 columns. Does
anyone know of any way to print all columns; i don't care if the
printout spans multiple pages.

Create a Report, with the fields laid out in whatever format you wish.
FYI, the records displayed in the sub-form are dynamically obtained
based on some ad-hoc querying in the main form. Any report, etc.
generated will have to have the same set of records.

Simply create an ad-hoc query, and base your report on that query.
Does the subform have different FIELDS - not just different data -
based on the query?
John W. Vinson[MVP]
Aug 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.