hiding fields on access reports 3

[clientuser]

Is there a way to make a field not visible on an access report if there is no data in that field? I have tried several things but nothing has worked...

 

[SBGibson]

on the onformat event of the section place:

if isnull(me!ctrlname) or me!ctrlname="" then
me!ctrlname.visible=false
else
me!ctrlname.visible=true
end if
Stevie B. Gibson

 

[clientuser]

That worked great.. Now can I take it even 1 step further... the fields that are not visible now on the report leave a gap.. is there a way to decrease this gap when these fields arent visible?

 

[SBGibson]

Uhm...I tried something like that...reduce the field to the minimum height..just to see the borders and set the CanGrow property to true.
It should work...I've a report that use this method Stevie B. Gibson

 

[MisterC]

ummmm.....
don't you mean to set the Can Shrink property to yes?

 

[SBGibson]

If I remember right using the shrink it don't shrink
I used the CanGrow property with a small Field Stevie B. Gibson

 

[MisterC]

Can grow will not make the field shrink; Can Shrink works fine if the field is empty.

Just put a few stacked text boxes on a report. Make the value of one in the middle empty and preview the report. If the can shrink property is 'No' you will see a gap between the displayed values.

Now set the can shrink property to 'Yes' and look at the report again. The other text boxes will collapse so no gap will be visible.

 

[MHadden]

Just a note to Stevie B. Gibson, I have been searching for the answer to this same question for several weeks, your suggestion worked for my problem. Even though I wasn't really in this conversation, I just wanted to say THANKS, Michael

 

[JoeMiller]

I answered a similar question in another thread (link below) which could be adapted to this problem. If you need further help please let me know!

thread703-80976 Joe Miller
joe.miller@flotech.net

 

[WSA]

Thank you Steve, that "Can Grow" on a hairline-thin field was what I needed to know as well!

regards,

WSA