Prev: Magnify glass on report preview
Next: Printing Reports Question
From: rchristopher on 17 Mar 2010 07:41
How code to make Field_label shrinkable dependent on field value in report?
Field value set to "can shrink" takes no vertical space in a report. How
code the Field_label to also take no space when the field value is null?
From: Allen Browne on 17 Mar 2010 07:57
Right-click the label, and Change To | Text Box.
Set the Control Source of the new text box to an expression like this:
=IIf([City] Is Null, Null, "City:")
replacing City with the name of your field.

Set Can Shrink to Yes for this text box (substitutes for a label.)

Providing nothing else overlaps these controls vertically, they should
shrink.

Check that the (Detail?) section has its Can Shrink set to Yes as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"rchristopher" <rchristopher(a)discussions.microsoft.com> wrote in message
news:ABD8535B-662A-4803-86CD-BF5115815282(a)microsoft.com...
> How code to make Field_label shrinkable dependent on field value in
> report?
> Field value set to "can shrink" takes no vertical space in a report. How
> code the Field_label to also take no space when the field value is null?

 | 
Pages: 1
Prev: Magnify glass on report preview
Next: Printing Reports Question