Prev: Draw a horizontal line after the last record is printed on each pa
Next: Using a query as base for report
From: Lydia on 11 Dec 2009 10:31
Hi Duane,

I have been able to draw vertical lines without problem. What about the
horizontal line at the end of report when report finishes printing the last
record and make the last vertical line meet the horizonal line perfectly?
Thanks.
--
Lydia Liu
Access/VB Programmer



"Duane Hookom" wrote:

> If you prefer code (I do) you can use the line method to draw vertical lines.
> Select each control in your detail section that you want vertical lines on
> the left and right. Set their tag property to "BorderMe". Then add code to
> the On Print event of the detail section:
> Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
> Dim ctl As Control
> For Each ctl In Me.Section(0).Controls
> If ctl.Tag = "BorderMe" Then
> Me.Line (ctl.Left, 0)-Step(0, 10000)
> Me.Line (ctl.Left + ctl.Width, 0)-Step(0, 10000)
> End If
> Next
> End Sub
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Fay" wrote:
>
> > Sorry for the long delay in responding. I have been finding Access quite
> > difficult to work with, in spite of many years of coding. In any case, this
> > is an Invoice that will have a variable number of rows. I only want the
> > vertical lines between columns to print. My solution has been to carefully
> > place vertical bars next to each control and then make sure the rows print
> > close enough to each other so that it appears as the the vertical lines are
> > attached to each other. Somehow, it seems a bit harder than it should be, but
> > maybe I am just spoiled.
> >
> > Thanks so much for your help.
> >
> > "Duane Hookom" wrote:
> >
> > > Can't you use borders around controls or rectangles around sections? Or, do
> > > one or more text boxes grow?
> > >
> > > --
> > > Duane Hookom
> > > Microsoft Access MVP
> > >
> > >
> > > "Fay" wrote:
> > >
> > > > I am setting up an invoice report that will contain one row for each item to
> > > > be included-- thus the number of rows will be variable. I would like these
> > > > rows to be in a tabular format with the vertical border lines between each
> > > > column displayed, as well as horizontal borders at the top and bottom of the
> > > > rows.
> > > > Thanks,
> > > > Fay
> > > > "Duane Hookom" wrote:
> > > >
> > > > > If you explain your requirements, someone can walk you through writing the
> > > > > code...
> > > > >
> > > > > --
> > > > > Duane Hookom
> > > > > Microsoft Access MVP
> > > > >
> > > > >
> > > > > "Fay" wrote:
> > > > >
> > > > > > Thanks. I was afraid that was the case.
> > > > > >
> > > > > > "Duane Hookom" wrote:
> > > > > >
> > > > > > > Most likely you will need to use VBA. You could set the picture property of
> > > > > > > the report but this would be a static size.
> > > > > > > --
> > > > > > > Duane Hookom
> > > > > > > Microsoft Access MVP
> > > > > > >
> > > > > > >
> > > > > > > "Fay" wrote:
> > > > > > >
> > > > > > > > I am trying to put a border around the detail section of a report that fits
> > > > > > > > around all rows, whether there be one or many, and is determined by the
> > > > > > > > number of rows. Can I do this without resorting to VB?
> > > > > > > > Thx.
 | 
Pages: 1
Prev: Draw a horizontal line after the last record is printed on each pa
Next: Using a query as base for report