How do I remove blank spaces in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I am very new to Access and I hope I can state my question in a clear
way. I am trying to combine information on several different businesses and
then create a summary of each- one business per page. I want the name of the
business, address, phone, fax, contact person and things like that to show on
this report. One of my specific problems is that for some of the businesses
I have many individuals listed as contact people and only 1 contact person
for other businesses. How do I get my report to not have empty spaces for
the empty fields? When I created my table, I had many fields for my contact
person, for example, Contact 1, Contact 2, Contact 3, etc. I then created
the report with all of those fields. I have a feeling this is a basic
question, but I cannot find the solution using the "help". Thanks.
 
Hi. I am very new to Access and I hope I can state my question in a clear
way. I am trying to combine information on several different businesses and
then create a summary of each- one business per page. I want the name of the
business, address, phone, fax, contact person and things like that to show on
this report. One of my specific problems is that for some of the businesses
I have many individuals listed as contact people and only 1 contact person
for other businesses. How do I get my report to not have empty spaces for
the empty fields? When I created my table, I had many fields for my contact
person, for example, Contact 1, Contact 2, Contact 3, etc. I then created
the report with all of those fields. I have a feeling this is a basic
question, but I cannot find the solution using the "help". Thanks.
Click to expand...

Set the Can Shrink property of each control, as well as the can shrink
property of the Detail section to Yes.
As long as there are no other controls on the same line, there will be
no blank spaces.
 
Back
Top