Suppressing Blank Fields in a Report

T

TGM

How would I go about suppressing blank fields in a report. If there is no
information on that field, I don't want there to be a blank space, I would
like it to continue on to the next entry. Please let me know if you can help.

Thanks
 
T

TGM

I'm sorry. This is my first time using this board. What I mean is I have a
simple list with multiple contacts for a particular company based on our
different departments. I.e. Dept. A Contact John Smith, Dept. B. No Contact,
Dept. C Contact Jane Doe. I would like my report to read

ABC Company
John Smith
Jane Doe

vs.

ABC Company
John Smith

Jane Doe

Is that a little bit better? I tried the Can Grow, Can Shrink, Height at
"0" however it makes the records uneven for some reason.
 
A

Allen Browne

Hi TGM. Welcome to the newsgroup.

You're on the right track with the CanShrink property. It sounds like you're
having some success, but either:
1) it's not collapsing all the blank lines, or
2) the space between records is not reducing.

If 2), make sure the CanShrink property of the (Detail?) section is also
set.

If 1), make sure:
a) There is nothing beside the control you want to shrink, not even its
label, or a line.
b) The controls do not overlap vertically (i.e. one extends down below where
the next one starts).

Please post back if that still does not solve the problem.

BTW, the best solution would probably be to create a related table for the
contracts. That way you can have as many contacts as you would like for a
company - even multiple contacts for a department if desired. When you
combine them in a query for your report, it returns the correct information
without the problem of all the blank fields.
 
Top