MAKE BOX AROUND DETAIL IN REPORT - CAN GROW?

[BlueWolverine]

Hello,
MS ACCESS 2003 on XP PRO.

I have a report where the detail on a given item can be any height. (CAN
GROW from options.)

But I want to box around the item. (1)If I do borders, they aren't smooth.
(2)If I draw a box, it doesn't grow. (3)If I make the detail sunken, half
the box doesn't print.

(1)

-------------------------------------------------------
| | | | |
----------| |--------------| |
|-------------| |------------|

Any ideas?

 

[Golfinray]

In the toolbox, there is a line (or draw line) command that will do just what
you need.

 

[BlueWolverine]

How can I make the vertical lines on the sides grow with (and to) the height
of each individual record, which will vary?

 

[Duane Hookom]

You can use the Line method in code. This must be written in the On Print
event of the section. The code involves looping through each control in the
section to find out which is the highest. Then use the Line method to draw
all boxes. This suggests you should set all of your borders to transparent.

If you need more assistance, search google on "Access Reports Line Method
Can Grow". Reply back if you need more help.

 

[Marshall Barton]

Hello,
MS ACCESS 2003 on XP PRO.

I have a report where the detail on a given item can be any height. (CAN
GROW from options.)

But I want to box around the item. (1)If I do borders, they aren't smooth.
(2)If I draw a box, it doesn't grow. (3)If I make the detail sunken, half
the box doesn't print.

(1)

The horizontal lines at the top and bottom of the section
can just be line controls, but to get vertical lines in a
can grow detail, you need to use the Line method in either
the section Format or Print event.

Me.Line (textbox1.Left,0)-Step(0,30000)
Me.Line (textbox2.Left,0)-Step(0,30000)
Me.Line (textbox3.Left,0)-Step(0,30000)
Me.Line (textbox3.Left+textbox4.Width,0)-Step(0,30000)

Note: since the lines will be cropped at the section
boundary, you can just draw really long lines without
knowing how much the section grows or shrinks.

 

[Rob Parker]

Helen Feddema has written a function to set the height of all textboxes in a
given section of a report to the tallest one. You can download an article
describing it in detail, and a sample database, from
http://www.helenfeddema.com/access.htm The download you need is
accarch104.zip.

HTH,

Rob