Blank Spaces in Report

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

Guest

Recently I made a report that show each EmployeeID, EmployeeName,
EmployeeRelationship (just Employee) & EmployeePremium under the main header.
Then under the detail header thing it shows the FamilyMemberName,
FamilyMember Relationship (Spouse, Child 1, etc) & FamilyMemberPremium. This
works great if the employee has a family. However, not every employee does,
so then the employee shows and then there is a blank line where a family
member would go before the next employee.

Is there a way to make this space disappear who the fields are blank?
Any help would be greatly appreciated!
Tandy
 
Try setting the Can Shrink property of both the control (e.g. text box) and
the report's Detail section to Yes. This is found on the property sheet.
Open the report in design view, click a blank area in the detail section,
then click View > Properties to see the detail section's property sheet.
Similarly, click the control (text box) containing the family member
information, then click View > Properties to set the control's Can Chrink
property.
 
Back
Top