Can shrink and borders

  • Thread starter Thread starter Sebastian Halliday
  • Start date Start date
S

Sebastian Halliday

I am trying to write a report which presents a set of addresses each within
a border. Since there are different numbers of lines in the various
addresses I want to use the Can Shrink property to avoid blank lines in the
report. However, the border prevents this property from taking effect. So
I can have a border and blank lines or no blank lines and no border.
Any way out of this?

--

---------------------------------------------
Sebastian Halliday
The Count House
Count House Lane
Carbis Bay
St Ives
Kernow TR26 2PY
01736 794786 email (e-mail address removed)
 
Sebastian

One approach is to use concatenation to build the address(s) as a long
string, with embedded carriage returns and line feeds. Placing the entire
string within a single textbox would allow you to grow/shrink that single
control, with its accompanying border.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top