Dynamically sizing text boxes

  • Thread starter Thread starter GH
  • Start date Start date
G

GH

I have 10 fields on a report. I would like to use VBA to find the height of
the tallest box then set the rest of the boxes to this same height. Can
anyone steer me in the right direction VBA wise?

Thanks in advance,
G Holt
 
You might have the best luck looping through your controls in the On Print
event of your report section. Find the tallest text box and then use the
Line method to "draw" rectangles around all text boxes. This method sets all
of the text box borders to transparent. I believe Stephan Lebans has some
code "PrintLines" at his site www.lebans.com.
 
Back
Top