Text box won't grow

[anthony]

In Access 2007 take an unbound report and put a textbox in the detail
section. Set the textbox to grow/shrink. In the onPrint event, create
a large string variable and bung it into the textbox. The textbox does
not grow. I have to explicitly size it in design view. My problem is
that I need several of these with page breaks between each one and the
detail section will not allow it as its size would exceed 55.5cm

Any advice?

TVM - Anthony

 

[Rick Brandt]

In Access 2007 take an unbound report and put a textbox in the detail
section. Set the textbox to grow/shrink. In the onPrint event, create
a large string variable and bung it into the textbox. The textbox does
not grow. I have to explicitly size it in design view. My problem is
that I need several of these with page breaks between each one and the
detail section will not allow it as its size would exceed 55.5cm

Any advice?

TVM - Anthony

Have you tried the Format event rather than the Print event?

 

[anthony]

Have you tried the Format event rather than the Print event?

Well, blow me down. I thought I'd tried that but I clearly hadn't as
it works! Is it by design that it doesn't work using onPrint?

Thanks very much

A

 

[Rick Brandt]

Well, blow me down. I thought I'd tried that but I clearly hadn't as
it works! Is it by design that it doesn't work using onPrint?

As the names of the events imply "Formatting" is still occurring in the
Format event whereas the Print event occurs AFTER all formatting is done.

 

[anthony]

As the names of the events imply "Formatting" is still occurring in the
Yes, that makes sense. I very much appreciate your help

Anthony