removing blank spaces from checkboxes and combo boxes

Marshall Barton wrote:
>>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
>


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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200809/1

Zanne via AccessMonster.com wrote:

>Marshall Barton wrote:
>>>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


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.

--
Marsh
MVP [MS Access]