hiding columns

[Chi]

Hi,

I have a report that has 17 fields. Therefore, it has two pages when I print
it off.

Is there a way that I can squeeze the 17 fields in one page report?
---------------
In Excel, we can hide or show columns when we need them or not. Can I
hide/show the fields on report?

Thanks
Chi

 

[Jeff Boyce]

Reports in Access are based on queries (ideally), or on tables. If your
report is based on a table with 17 fields, you are still not required to
include all the fields/controls on your report.

A preferable approach would be to create a query that only returns the
fields/columns of data you need in your report, then base your report on
that query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cna48]

Chi,
You should be able to go into properties of each field. Go to "Format"
and select no under "visible" this will hide the data but it will still
occupy that space. Hope this helps.