Can shrink not responding

[Alp Bekisoglu]

Hi Experts,

A2K report having 6-7 fields arranged vertically. All have can grow & can
shrink properties set to yes. The detail section of the report also has its
can shrink property set to yes.

Problem is nothing shrinks, so to speak, and everything (the labels of blank
fields) gets printed. I thought the can shrink property would suppress the
label as well if the field has no data.

Am I missing something or is there another way of accomplishing this in
Access?

Thanks in advance,

Alp

 

[Rick Brandt]

Hi Experts,

A2K report having 6-7 fields arranged vertically. All have can grow &
can shrink properties set to yes. The detail section of the report
also has its can shrink property set to yes.

Problem is nothing shrinks, so to speak, and everything (the labels
of blank fields) gets printed. I thought the can shrink property
would suppress the label as well if the field has no data.

Am I missing something or is there another way of accomplishing this
in Access?

Thanks in advance,

Alp

CanShrink will not shrink labels. It is mostly used in situations where the
output is tabular (labels at the top in one section and TextBoxes only in
the section below that shrinks).

 

[Allen Browne]

No. Labels don't shrink.

Right-click the label, and choose:
Change To | Text box

Then set its Control Source like this:
=IIf([City] Is Null, Null, "City:")
replacing City with the name of your field.

Then set the CanShrink property of this new text box as well.

 

[Access101]

I suppose you could use an If IsNull(TextBox) then Label.visible = False

You'll have to reset it for not is null

No. Labels don't shrink.

Right-click the label, and choose:
Change To | Text box

Then set its Control Source like this:
=IIf([City] Is Null, Null, "City:")
replacing City with the name of your field.

Then set the CanShrink property of this new text box as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Experts,

A2K report having 6-7 fields arranged vertically. All have can grow & can
shrink properties set to yes. The detail section of the report also has
its can shrink property set to yes.

Problem is nothing shrinks, so to speak, and everything (the labels of
blank fields) gets printed. I thought the can shrink property would
suppress the label as well if the field has no data.

Am I missing something or is there another way of accomplishing this in
Access?