Print all columns of subform in datasheet view

  • Thread starter Thread starter ghat12
  • Start date Start date
G

ghat12

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

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

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]
 
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
 
Back
Top