By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Access report - growing text box problem!

Expert 100+
P: 218
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
Sep 20 '07 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,492
Why no luck Steve?
That's the way I'd play it I think.
Sep 20 '07 #2

FishVal
Expert 2.5K+
P: 2,653
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.
Sep 20 '07 #3

FishVal
Expert 2.5K+
P: 2,653

NeoPa
Expert Mod 15k+
P: 31,492
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.
Sep 22 '07 #5

Expert 100+
P: 218
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
Sep 24 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.