Access report - growing text box problem!

[cyberdwarf]

Hi,

I have a report with a repeating detail section, containing a text field (which can grow), plus three more text fields, which cannot grow.

These fields are horizontally aligned.

This detail must have a border, plus vertical dividing lines between the fields.

My problem is that I cannot find a way to produce vertical dividing lines which will grow to the same height as the expanding text box. I have tried using the format event of the Detail section to adjust the height of the non-growing text boxes and to adjust the height of the vertical dividing lines.

But no luck!

Am I barking up the wrong tree, or is this just not possible?

Any suggestions gratefully accepted.

TIA

Steve

[NeoPa]

Why no luck Steve?
That's the way I'd play it I think.

[FishVal]

No ideas. Sorry.
Just subscribing.

P.S. I've been stucked with the same problem. But figured out nothing but to make a report in Word file.

[FishVal]

Jim has figured it out.
Report Text Box Height - Always the same height as the detail section

[NeoPa]

That's a clever solution Fish, but a workaround (not that that means it's necessarily bad).
I would have thought that amending the height of the various controls should also be possible (I'm pretty sure I've done similar things myself, though I can't find the actual code). Maybe that doesn't work as I'd expect, but if it does, it would surely be a better and lower overhead approach.

Steve, let us know how you manage to get this to work in your db and/or if you have more questions on it that we might be able to help with.

[cyberdwarf]

Got an answer!

I used the report LINE method in the OnPrint event of the detail section.

Of course it can be a PITA to position the lines to the correct co-ordinates, but the final dimensions of the detail components are not available until then.

Also note that the help on the Line method syntax is not only woefully inadequate, but also WRONG!

See :-

http://groups.google.com/group/micro...ea269b0dceb17e

and

http://ewbi.blogs.com/develops/2003/..._draws_a_.html

HTH

Steve