initial letter only/can shrink

  • Thread starter Thread starter Evelyn Ballantyne
  • Start date Start date
E

Evelyn Ballantyne

Dear Albert, Yes I can see exactly how it should work but
its driving me mad cos the box will not shrink, it still
shows the blank line

|=([address1]+"")| also tried without the +""
|=([address2]+"")| " " "
|town|
and set can shrink to yes for the three texboxes on the
report.
and yes if i can get it to work, its far better than all
my code!!
 
Dear Albert, Yes I can see exactly how it should work but
its driving me mad cos the box will not shrink, it still
shows the blank line

|=([address1]+"")| also tried without the +""
|=([address2]+"")| " " "
|town|
and set can shrink to yes for the three texboxes on the
report.

You need to set the "Can Shrink" property for the section containing the
textboxes to "Yes", also. Make sure, too, that there are no other controls
overlapping the lines on which your textboxes are or they may interfere with the
shrinking (in other words, there can't be any controls to the left or right of
the textboxes).
 
Evelyn Ballantyne said:
Dear Albert, Yes I can see exactly how it should work but
its driving me mad cos the box will not shrink, it still
shows the blank line

|=([address1]+"")| also tried without the +""
|=([address2]+"")| " " "
|town|
and set can shrink to yes for the three texboxes on the
report.
and yes if i can get it to work, its far better than all
my code!!

=([address1] + "")

In the above, the idea here is to add a space IF the field exists. But since
you only have the one field, then:

=([address1])

Should work. In addition, you can even use the drop down box to set the
source for the text box, and thus use:

address1

The can shrink option does not work if the text boxes over lap. Perhaps that
is the problem. Another possible is that you have spaces, or blanks in your
actual data, as this also will prevent the can shrink.

You could try:

=Trim([address1])
 
Yes, setting the can shrink for the detail section is *usually* needed.
Unfortunately, the original poster is printing labels, so you don't want the
detail section to shrink in this case, but just the fields to move up.

(this why hopefully the original poster should have continued on the
original thread!).
 
Back
Top