Resizing textboxes

[akacoroski]

I have a report with multiple textboxes in the Detail section, and each textbox has CanGrow enabled. I want to keep all textboxes the size, i.e. when one grows they all grow such that on print or view, each is the size of the largest.

The built-in events OnFormat and OnPrint don't seem to work. OnFormat fires after data is loaded but before formatting, so there is no way to know for sure how much growing will occur. OnPrint doesn't allow resizing of textboxes (at least in Access 2000).

Any suggestions?

 

[dhookom]

I assume you want the borders to look like they are all the same height. The method I use is to write code in the On Print event of the section that checks for the maximum height of all text boxes and then uses the Line method to draw the boxes/rectangles. Make sure the borders of your text boxes are set to transparent.
There is an example of this in the Calendar report demo at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

Duane
MS Access MVP