469,267 Members | 922 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

Print all columns of subform in datasheet view

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
2 3960
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
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.

Similar topics

4 posts views Thread by wayne dooley | last post: by
1 post views Thread by Matthew Wells | last post: by
2 posts views Thread by Smartin | last post: by
7 posts views Thread by Ken Mylar | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.