Printing a horizontal line at the bottom of the Detail section

[Carl Rapson]

I would like to print a horizontal line at the bottom of my Detail section.
The problem is, I have several fields set as Can Grow in the Detail section.
Consequently, the Detail seciton can be of varying height. I've tried the
Line method:

Me.Line (0, Me.Section(acDetail).Height)-Step(Me.Width, 0), vbBlack

But this always draws a line at the default Detail section height (the
height I see in Design view), not the actual (runtime) Detail height. How
can I draw a line at the bottom of the Detail section when the section
height keeps changing?

Thanks for any information,

Carl Rapson

 

[Terry]

Carl,

In design view draw your line at the bottom of the detail
section and ensure none of the "growing" controls overlap
vertically with the line. No need for any code.

HTH

Terry

 

[Stephen Lebans]

Place your code in the Print event and change the reference from:
Me.Section(acDetail).Height
to
Me.Height

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Carl Rapson]

Thanks, Terry. I wasn't aware that the cotrols "overlapping" would cause
that problem.

Carl

 

[Carl Rapson]

Thanks, Stephen, that worked. I've been drawing lines in the Format event,
and everything worked except for this one problem. Should line drawing take
place in the Print event instead?

Carl

 

[Stephen Lebans]

In CanGrow/Shrink situations, the final height of the control/section is
not available until the Print event. So as you suggested, all calls to
the Report object's Line/Print etc methods should happen in the
section's Print event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Carl Rapson]

Thanks, that's good to know.

Carl

In CanGrow/Shrink situations, the final height of the control/section is
not available until the Print event. So as you suggested, all calls to
the Report object's Line/Print etc methods should happen in the
section's Print event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.