removing blank spaces from checkboxes and combo boxes

[Zanne]

I have a form that hides checkboxes and combo boxes if they have no value,
and this is creating large areas of blank space on my reports. How can I
remove this blank space? I've canshrink property applies to text boxes, but
I don't see a way to apply it to other controls. Any ideas?

 

[Marshall Barton]

I have a form that hides checkboxes and combo boxes if they have no value,
and this is creating large areas of blank space on my reports. How can I
remove this blank space? I've canshrink property applies to text boxes, but
I don't see a way to apply it to other controls. Any ideas?

You can get CanShrink to work if you change the check boxes
to text boxes a la http://allenbrowne.com/ser-52.html

 

[Zanne via AccessMonster.com]

You can get CanShrink to work if you change the check boxes
to text boxes a la http://allenbrowne.com/ser-52.html

Would this solution work for text as well? Instead of a symbol, I would like
it to say "adjacent lot."

 

[Marshall Barton]

When you use a text box, it can shrink if:
its value is Null
its value is a zero length string
its Visible property is False

To get different text for true/false values, set the text
box's Format property to something like:
;"value is true";"value is false"

If you look at Allen's example, you can see that it's the
same thing with ab odd font amd character for the "value is
true" string and a ZLS for the "value is false" string.