How can I make lines grow in the report?

[seaport]

I am creating a report in Access97. In the detail section there are multiple verticle lines. What I want to do is to make the length of these lines grow as the height of the detail section grows, so the report looks like an excel worksheet. Is it possible to do this?

 

[DougP]

NOPE <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[famousb]

You can't technically make the lines grow, but if you're trying to accomplish what is it that i think you are, you can have only the rows of data that you want the lines to encompass in the detail section of the report (put the categories, what would be the column headers in Excel, in the Page header section). You can then make the vertical lines reach from top to bottom of the detail section which will repeat for each additional record that is added - giving the effect of extending the lines. This just limits what else you can include on the page, but works to create Excel-like spreadsheets. Feel free to email me if you need a better example. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[JimConrad]

Do you have text boxes in the detail area which may grow at runtime because of the amount of data in them?<br>
<br>
So as the detail line gets taller, you also want the vertical lines to fill the section? <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[JimHorton]

You're only option is to make the textboxes butt against each other, and set the CanGrow to Yes for the textbox controls.<br>
--Jim

 

[seaport]

Thanks for all your responses.<br>
<br>
There are several textboxes in the detail sections. I can not make their border visible (to make the report look at a grid) since there is no reason to believe that they will grow to the same height.<br>
<br>
I just found a line method in the Help File of Access 97. But I am not sure I can get what I want with this method.<br>

 

[DougP]

If you want to have a line under the text in a texbox<br>
turn on the &quot;Underline&quot; Property<br>
It will underline just the text at that time so it will grow to what ever text is int that box.<br>
<br>
OK<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[JimConrad]

Seaport -- Were you able to make the &quot;Line&quot; method work?<br>
<br>
If not, send me an email or look in the Solutions.mdb that was supplied with your copy of Access. It shows a similar problem (how to draw a circle around a number on a report -- at runtime). <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[seaport]

I finally figured out a way to do it, although I am not very satisfied with it.<br>
<br>
I used the sub DrawLine() fromt the example of &quot;Line&quot; method in the help file of Access97 and made a little modification to make it draw a verticle line.<br>
<br>
Then from report_page event procedure I call Sub Drawline, so that there are verticle lines in every page from the top to the bottom and there is no break in these lines.<br>
<br>
Also, in the first page I specify the starting position of these lines so that they won't run across report header section.<br>
<br>