Can shrink not responding

A

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
 
R

Rick Brandt

Alp said:
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).
 
A

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.
 
A

Access101

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

You'll have to reset it for not is null


Allen Browne said:
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.

Alp Bekisoglu said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top