Set the Height/Width of a Text Box

[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?

 

[Marshall Barton]

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?

I have seen that a few times. I'm not sure, but it seems
like it has something to do with the font and maybe(?) the
text box's border thickness(?). Whatever it is I just add a
fudge factor of 50 or so twips to the value returned by
fTextHeight.

 

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