Shrink hidden fields in report

[Flynners]

Hello there
I have a report that functions as a letter to suppliers. I have fields in the letter that maybe be 0 or zero due to data entry rules (filling all fields/ locking records after all fields entered/creating totals.) I dont want these to be displayed and have code in the onload event if zero or 0 then not visible.

As there is always data in these fields at report stage - even if it is "0", the "shrink" option does not apply. How can I move up a text box from the bottom of the page if the content of these fields is "0" or "zero" - rather than leaving white space where there are hidden fields.

I have used twips on forms to move left but am struggling with the correct syntax to move up on report. Is there any other method i could use.

 

[Addyman]

I'm sure I had this issue a while ago. If I remember correctly, my workaround was for the text box in question, I set it's height to be very small, such as 0.01cm or whatever the smallest allowed was. I then set the Can Grow Property to Yes.

So, if it is null or 0 and you hide it, you are only leaving 0.01cm of white space. However, if there is data in it to be displayed, it will grow to be big enough to show you data and will 'push' the text box below it down.

Kind of a backwards way of solving it, but it worked for me

 

[Flynners]

good idea, never thought of that, i will give it a shot
Thanks Addyman

 

[Addyman]

One of the things I love about working with Access, there is nearly always a way of doing what you want, you just sometimes have to think a little laterally

Hope it works OK for you.

 

[my2cents]

Sorry - another option is to put formula in data parameter: =IIF([FIELD1]<>0,[FIELD1],"") and then set Can Shrink to 'yes'