Set the Height/Width of a Text Box

T

terri

I have several reports with multiple textboxes arranged vertically that need
to dynamically "stretch" to accommodate variable lengths of data (and I
CANNOT concatenate the text):

Col A ColB Col C
----------------------------
Text1 Memo Text1
Text2 Text2
Text3

Can Grow/Can Shrink is erratic at best in this kind of layout. I am using
Stephen Lebans' TextHeightWidth utility to determine the required heights and
handling the arrangement of controls and section sizes manually. With the
number of controls involved, it is depressingly slow in processing but it
seemed to be working well. However, a closer look is revealing sporadic
cases where a full line of text is not being accomodated (the height returned
is too short). I have seen no issues with the width calculation. Has any
one experienced this?
 
T

terri

Thanks Marshall.

FYI - I'm using transparent borders and draw all vertical and horizontal
lines using LINE. I first noticed the problem when I changed from Arial to
Times New Roman. (Users can select the font.) Widening the control just a
smidge corrected it in my test data, but switching font sizes (again a
user-specified option) caused it to re-appear. I'm limiting the available
font sizes to 3 choices, so as long as the issue doesn't extend past one line
not displaying, a fudge factor is do-able.
 

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