Vertical lines and grid

  • Thread starter Thread starter John S
  • Start date Start date
J

John S

Hi...

I am trying to create a crosstab report with grid lines vertical and
horizontal. Its all done except I want the vertical lines to stop
(truncate/crop) at the bottom of the detail section of each page and
obviously at the end of the report.

Any help with the code would be appreciated. I have 23 vertical. I have used
actual horizontal lines in the report detail section but I CANNOT GET THEM TO
MEET EXACTLY! An example of the code I’m using in the reports Detail_Print
sub is:

Me.Line (1.57 * 1440, 0)-Step(0, 20 * 1440)

Regards,
John.
 
Try:
Me.Line (1.57 * 1440, 0)-Step(0, Me.Section(0).Height)

If this doesn't work, tell us if these are too long or too short or what.
 
Try:
Me.Line (1.57 * 1440, 0)-Step(0, Me.Section(0).Height)

If this doesn't work, tell us if these are too long or too short or what.
 
Thanks Duane,

It worked perfectly...

By the way, it took me ages to line up the 23 vertical lines on my report
with the texts boxes. I had to perform conversions from cm to inches for the
code. Is there a quicker/easier way of calculating the position of vertical
lines in relation to multiple text boxes?

Regards,
John.
 
Thanks Duane,

It worked perfectly...

By the way, it took me ages to line up the 23 vertical lines on my report
with the texts boxes. I had to perform conversions from cm to inches for the
code. Is there a quicker/easier way of calculating the position of vertical
lines in relation to multiple text boxes?

Regards,
John.
 
Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
I thought within code, all the measures are twips. You can change this to
another scale mode if needed.
 
I thought within code, all the measures are twips. You can change this to
another scale mode if needed.
 
Back
Top