Suppressing Blank Fields in a Report

[Guest]

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

 

[Joseph Meehan]

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

A little more information please.

Do you mean you don't want a new line of data or do you want:

"abc def jkl" On one line

rather than:
"abc def ghi jkl" On one line?

 

[Guest]

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.

 

[Joseph Meehan]

I'm sorry. This is my first time using this board.

Don't worry about that.

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.

Yes that is better and now I have another question. How is this data
store?

Do you have a company table linked to a contact table?

 

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