Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to delete extra spaces in a report when columns are hidden

Status
Not open for further replies.
Mar 9, 1999
11
0
0
US
Office 95/Access v7.0 on Win 95 laptop: I have a report based off a query. The query has a "description" filter that I can type in processor, or monitor, or keyboard, etc... and it will pull the information based on this filter. I have certain fields I don't want shown in the report, and have gotten them to "hide", but there is a big white gap in my report where that column was located. I have tried re-arranging my report, but still come up with white space as there is too much mix of hidden and non-hidden fields based on the description. How do I get the report to choose only the fields I want and then compress the report to eliminate any "white space" due to non-wanted columns? Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top