Expand (grow) an entire record on coninutous form 1

[perrymans]

I have a continuous subreport with 5 fields. One of the fields may get long and wrap the text around to another line. To display this additional text, I have set the Detail Section and textbox properties of CanGrow and CanShrink to Yes.

The problem is that it is the only field that grows. I need them all to grow to match the largest textbox size in the record (I am using borders on the textboxes so it is very noticeable).

Any ideas? Thanks. Sean.

 

[dhookom]

Remove all borders from the text boxes and use code in the On Print event of the section to draw the rectangles using the Line method. Stephan Lebans has some code "PrintLines" at his web site

http://www.lebans.com.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.