How to grow two text boxes to same extent.

[Sanjay Srivastava]

I have a very challenginig problem for access lovers.
I have got two text boxes in detail section on a report.
The " Can grow " property is set to yes and the border of
these text boxes is "solid" or not transperent. When there
unequal amount of text data in the two boxes both of them
grow to different extent. This makes a very untidy
appearence.Can they be made to grow to same extent? I have
not been able to find any direct or round about way.
Kindly help.
Sanjay

 

[Stephen Lebans]

There are 2 solutions available.

1) If you are working with A2K or higher then you are able to
programmatically set the height of the Detail section within its Format
event. This ability is required as Access will set and maintain the
Detail height at the largest value you force programmatically.
From the Format event you will:
a) Use the TextWIdthHeight functions on my site to ascertain the largest
hieght for the TextBox control in the section.
b) Set the Height of all of your TextBox control's to match the largest
value.

OR
2) Use the Line method of the Report object to draw the
lines/borders/grid desired from the section's Print event. Sample code
is here(see the older non class based PrintLines samples to get you
started).:
http://www.lebans.com/PrintLines.htm


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.