Re: Multi-Column Report - Add a border and line between columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This works perfectly except I am confused on how I can make the rectangle
move down about an inch. I can't seem to figure that out. Any help would be
great.

Thanks in advance

"Duane Hookom" wrote:

> You can add code like:
> Private Sub Report_Page()
> Dim intLineCount As Integer
> Dim intColumnWidth As Integer
> Dim intReportHeight As Integer
> intReportHeight = (9 * 1440)
> intColumnWidth = 2800
> For intLineCount = 0 To 4
> Me.Line (intLineCount * intColumnWidth, 0)-Step(0, intReportHeight)
> Next
> Me.Line (0, 0)-Step(4 * intColumnWidth, intReportHeight), , B
> End Sub
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B5BB554B-2AB9-4D1F-B6A6-E0C40537E4F3@xxxxxxxxxxxxxxxx
> > Does anyone know a way to put a border around a report and between the
> > columns of a multi-column report? I tried just adding the lines in the
> > report detail and it did not give a line on the far right side plus the
> > border was not complete if there were not enough records to fill the whole
> > page.
> >
> > Thanks in advance,
> > John
>
>
>
.

Relevant Pages

  • Re: how do i put a border round a report i created in design veiw?
    ... Sorry to be dim, but could you please explain in more ... >> exactly howdo i put a border around a report i ... >> my origional design but if i can't put a border on a report that ...
    (microsoft.public.access.reports)
  • Re: Multi-Column Report - Add a border and line between columns
    ... Private Sub Report_Page ... Dim intColumnWidth As Integer ... > Does anyone know a way to put a border around a report and between the ...
    (microsoft.public.access.reports)
  • Re: Dim oRpt As New CrystalReport1() failing
    ... I do not work with strongly typed reports - I create report files ... Dim paramFields As New ParameterFields ... > Dim paramFields As New ParameterFields ... > reference to "Dim oRpt as New CrystalReport(), ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Dim oRpt As New CrystalReport1() failing
    ... I do not work with strongly typed reports - I create report files ... Dim paramFields As New ParameterFields ... > Dim paramFields As New ParameterFields ... > reference to "Dim oRpt as New CrystalReport(), ...
    (microsoft.public.vb.crystal)
  • Fw: Page Nine No. 8
    ... The Uninvited Ombudsman Reports ... National Guard troops will be used to update maps of the U.S.-Mexico border, ... The lengthy "news" report, violating the most basic ethical principles, ...
    (misc.survivalism)