Suppress Check Box

[Guest]

How do you suppress the blank spaces in a report between the suppressed check
boxes?

Me.lblSomething.Visible = Me.chkSomething
Me.chkSomething.Visible = Me.chkSomething

This only hides the object field not the spaces. I also already changed all
fields on the report to "can Shrink". I also tried the:

=IIf([me.something] Is Null,Null,"me.something:")

however it stlii just makes the information not appear and it leaves blanks.

 

[Larry Linson]

Can Grow and Can Shrink only work in the vertical direction, not
horizontally, and shrink only if there is not some unshrunken field
alongside them. Is that what you are experiencing? What, exactly, did you
expect to happen?

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry, I was able to research the problem through other threads and it was
that I needed to have each field toching each other for the shrink to
work....in other words no black spaces between each text box

Can Grow and Can Shrink only work in the vertical direction, not
horizontally, and shrink only if there is not some unshrunken field
alongside them. Is that what you are experiencing? What, exactly, did you
expect to happen?

Larry Linson
Microsoft Access MVP

How do you suppress the blank spaces in a report between the suppressed
check
boxes?

Me.lblSomething.Visible = Me.chkSomething
Me.chkSomething.Visible = Me.chkSomething

This only hides the object field not the spaces. I also already changed
all
fields on the report to "can Shrink". I also tried the:

=IIf([me.something] Is Null,Null,"me.something:")

however it stlii just makes the information not appear and it leaves
blanks.