Lines do not grow in detail section

[Guest]

I am creating an Access 2000 report for the client in which they want to mimic an excel report (Don't figure). Anyway, they want column lines and no row lines. When a control in the detail section grows, the lines leaves gaps and resembles a dotted line rather than a column line.

Ive tried setting the height of the line to the height of the detail section and also setting the height of the line to the height of the control that grows. I've put this coding in the OnPrint, OnFormat, and OnRetreat event of the Detail section with no luck.

Any pointers
Thank

 

[Marshall Barton]

I am creating an Access 2000 report for the client in which they want to mimic an excel report (Don't figure). Anyway, they want column lines and no row lines. When a control in the detail section grows, the lines leaves gaps and resembles a dotted line rather than a column line.

Ive tried setting the height of the line to the height of the detail section and also setting the height of the line to the height of the control that grows. I've put this coding in the OnPrint, OnFormat, and OnRetreat event of the Detail section with no luck.

You can not make a Line control grow to match a CanGrow text
box. The size of the text box (and detail section) is not
known until the Print event, but the Print event is too late
to change the Height of the line control.

The way to get a line the full height of the detail section
is to use the Line method to draw the line. This needs to
be in the detail section's Print event:

Me.Line (Me.textbox1.Left, 0) - Step(0, 20000)
Me.Line (Me.textbox2.Left, 0) - Step(0, 20000)
. . .
Me.Line (Me.textboxN.Left, 0) - Step(0, 20000)
Me.Line (Me.textboxN.Left + Me.textboxN.Width, 0) - Step(0,
20000)

You don't have to worry about how high the detail section
grows, because the line will be cropped at the section
boundary.

 

[Guest]

Thanks Marshall that worked great
----- Marshall Barton wrote: ----

Bob R wrote

I am creating an Access 2000 report for the client in which they want to mimic an excel report (Don't figure). Anyway, they want column lines and no row lines. When a control in the detail section grows, the lines leaves gaps and resembles a dotted line rather than a column line.

You can not make a Line control grow to match a CanGrow tex
box. The size of the text box (and detail section) is no
known until the Print event, but the Print event is too lat
to change the Height of the line control

The way to get a line the full height of the detail sectio
is to use the Line method to draw the line. This needs t
be in the detail section's Print event

Me.Line (Me.textbox1.Left, 0) - Step(0, 20000
Me.Line (Me.textbox2.Left, 0) - Step(0, 20000
. .
Me.Line (Me.textboxN.Left, 0) - Step(0, 20000
Me.Line (Me.textboxN.Left + Me.textboxN.Width, 0) - Step(0
20000

You don't have to worry about how high the detail sectio
grows, because the line will be cropped at the sectio
boundary