Report cells will not collapes

[Brian62]

I have a report that I can not collapes the blanks cells. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set to pull by Principal investigator. If you look at the database I have attached you will see exactly what I am talking about. I need all blanks to collapes so it is all together instead of empty lines.



Thanks!

[ajetrumpet]

if noone on the Access World Forums has replied to you Brian, the chances of getting an answer here is even less. go with the one that has more exposure. the same experts that linger over there, also linger here.

[Brian62]

Is there another forum you can recommend? I'm in desperate need to figure this out. Thanks!

[ajetrumpet]

what is it for? work? if you haven't claimed to know how to do it already and committed yourself to knowledge, why not ask for help at work?

[Brian62]

Because at work they ask me for help with all sort of computer and program issues. I know Access pretty well but can't figure this one out, so I thought I'd reach out for help on this forum..... If someone at work had the answer I wouldn't reach out for help.... So can you help me????

[Brian62]

I tried this formula in the report and recieved (Com-Doc #2) 0 and (Com-Doc # 37) -1. However, it did collapes the text box blanks. I just probably need it fine tuned to get the text to show versus numbers.

=[Com-Doc #2] & " " & [Com-Doc #25] & " " & [Com-Doc # 37]=[Com-Doc #2] & (" "+[Com-Doc #25]) & (" "+[Com-Doc # 37])