Blank Spaces in Report

T

Tandy

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
 
B

BruceM

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.
 
T

Tandy

Hi Bruce! Your suggestion worked perfectly! I really appreciate your help!
Thanks,
Tandy
 
Top