Invisible but still taking up space on my report...???

[Randomblink]

I have created the code to turn certain fields invisible based on a single field...
Now my problem is I have HUGE blank areas where those fields are invisible...How do I make those blank spaces go away...?
Can anyone help me...?

 

[Rich]

Can't you use a query to restrict the report, then use can shrink grow?

 

[pdx_man]

Are you refering to horizontal space (up/down) or verical space (left/right). I think you're talking about the latter, which you are going to have to move your controls with code changing the Left and Top values.

If ThisCondition then
control1.visible = false
control2.top = control1.top
control2.left = control1.left
Else
control1.visible = true
control2.top = Cont2OrigTop
control2.left = Cont2OrigLeft
EndIf

remembering to store the original values.

 

[Randomblink]

Here is my connundrum...

In my report, there is a section called Design Details...Well, if the record/project is a City Project then there are certain fields used...if it is a Contract Project, then again, only certain fields are used...
Some fields are shared between, Like for instance, both kinds of Projects have a Meeting Date...But only Contract Projects have a Contract Date...and only City Projects have etc, etc...

SO I have to do a lot of hooyaw just to make this thing work...Can Shrink doesnt work if it is invisible...apparently...

Maybe I will try to make them empty if they are invisible...hmmm...that might make the can grow can shrink thing work for me...

Ah well...if you think you can help me...please do...if not, dont laugh too hard please...

 

[Pat Hartman]

Set both the can shrink and can grow properties of the detail section and each control in the section to yes. Make sure that no control overlaps (or even touches) any other. Organize the fields so that the common ones are on the same line. ALL of the controls in any given line need to be empty/hidden for can shrink to work.

 

[Sorrells]

Pat,

In my report on the detail line I have overlapping fields but on the second line, I have a single control that does not overlap.

The 2nd control and the detail line are set to can grow/shrink. I can of course set the upper line controls as well (and will) but wondered if the overlapping on the 1st line was stopping the shrink process.

I only want the 2nd line to shrink, the 1st will always print.

Could you clarify for me?

 

[Pat Hartman]

You'll need to test it to see if the overlap on line 1 is causing the problem. It is possible that because there is ANY overlap in the section, the section won't shrink.