Terry Lo via AccessMonster.com said:
I have a section that contains labels with IsNull statements. So if no
values are there they should not appear. Well they don't appear but a page
prints anyways. Does just the fact that they are encoded in there cause it
to print? Is there anyway to create some type of NoData event here? Thanks
The Controls have a CanGrow and a CanShrink property . . . If CanShrink is
set to Yes, and there are no other controls horizontally aligned with the
Control that is empty/null, then they will shrink to nothing. Report and
Group Headers and Footers and the Detail Section also have a CanShrink
property, so they will shrink correspondingly. The Page Header and Footer do
not have a CanShrink property.
The Label Control isn't associated with "statements", so I don't fully
understand what you mean.
If my response doesn't answer your question, please clarify with explanatory
details.
Larry Linson
Microsoft Access MVP
