Vertical lines and grid

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.
 
D

Duane Hookom

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.
 
D

Duane Hookom

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.
 
J

John S

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.
 
J

John S

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.
 
D

Douglas J. Steele

Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
D

Douglas J. Steele

Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
J

John S

Doug,

Yes - but only in cm!

Douglas J. Steele said:
Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
J

John S

Doug,

Yes - but only in cm!

Douglas J. Steele said:
Can you not determine the actual values of the Left (and possibly Width)
fields for each of the text boxes?
 
D

Duane Hookom

I thought within code, all the measures are twips. You can change this to
another scale mode if needed.
 
D

Duane Hookom

I thought within code, all the measures are twips. You can change this to
another scale mode if needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vertical Line Issues 2
Vertical Line Help 2
Subreport is not showing horizontal lines 11
Report grid lines 2
Grow Vertical Line 11
vertical lines on report header 1
grid lines in group header 2
me.line format 5

Top