Vertical Line 2 Column Report

[Tim L-B]

Hi all

I would like to divide a 2 column report with a vertical line. Any ideas please

TIA

Tim L-B

 

[GohDiamond]

In the REPORT DESIGN VIEW - Draw a vertical line between the two fields in the DETAIL section of your report that is the height of the section. When you print preview or print, You'll see a continuous line between the two field results for the DETAILs that are in the report. If you have a Page header with header labels draw a vertical line from the bottom of the PAGE HEADER section of the report as tall as you want it and align it with the vertical line in the details section. you can have headers labels on either side to indicate the content of the fields below. A nice horizontal line under the headers will make things look well organized.

Hope that helps

Goh

 

[Tim L-B]

In the REPORT DESIGN VIEW - Draw a vertical line between the two fields in the DETAIL section of your report that is the height of the section. When you print preview or print, You'll see a continuous line between the two field results for the DETAILs that are in the report. If you have a Page header with header labels draw a vertical line from the bottom of the PAGE HEADER section of the report as tall as you want it and align it with the vertical line in the details section. you can have headers labels on either side to indicate the content of the fields below. A nice horizontal line under the headers will make things look well organized.

Hope that helps

Goh

Sorry I didn't explain. The report consists of two fields that are formatted into two columns (Now 4 across) through page set up so that adding a vertical line doubles up on the right hand side. Thanks Appreciate the quick response.

 

[Tim L-B]

Formatting the source query as 2 columns only seems possible if the data runs horizontally. Becomes a problem when you want the data filling column 1 before starting column 2. If MS Works can have a dividing line option when selecting multiple columns why not Access ??

 

[GohDiamond]

Let me see if I've got this correct in my mind now. You have a list from a query consisting of 2 fields, say Name and Phone, and you have created a report with pagesetup designated DOWN then ACROSS. So now your page should look like : NAME PHONE | NAME PHONE : is that correct?

Goh

 

[Tim L-B]

Thats correct. A two field report (Number & Description) set to print in 2 columns (Down & then Across) using the column option in page set up. What I would then like to do is to divide them with a vertical line. IE:
Number Description (VL) Number Description. Using the report.line action will obviously create an unwanted line on the extreem right, also any ideas on taking the line through the section headers.
Thanks
Tim LB

 

[GohDiamond]

I have a partial answer for you, but I'm afraid I can't seem to get the list to print down the page. See the help named:Examples of reports that start each group in a new row or column. Create a Group from one of the fields by right clicking in the white are of the detail and seleccting Sorting and Grouping from the Popup menu, Slect one of the fields from the Field/Expression Menu, add the Group Header from the Group Properties; set the Page setup to print 2 columns down and across...

RightClick on the new Group header you created and select properties, In the New Row or Col property select BEFORE SECTION

Tha's where I get stuck....

The help seems to indicate that the list should print down the page but in print preview I only see two records to print.

I'm hoping somebody else can enlight us a little because if we can get this to work I believe we can add the vertical lines as I mentioned before. And I just tried the vertical line and they work if you set the column width to half the page width and place the vertical line neat the right edge so that your printer won't even print it out (just a little trick we play on th printer here). If only we could get the records to print down the page per the page setup.

Making some headway though. I'll let you know if I solve the puzzle and if you do first then let me know.

Goh

 

[Tim L-B]

I am so close now thanks to the printer tip. The only small problem is a small gap at the bottom between the vertical line and the base page footer horizontal line. Its very minor but it would be nice to have 100% success.

The header & detail format code is as follows:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.header) Then
Me.MoveLayout = False
Me.PrintSection = False
Me.Line18.Visible = False
Else
Me.Line18.Visible = True
Me.Line (3.9 * 1440, 0)-(3.9 * 1440, 14400)
End If
End Sub

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ScaleMode = 1
Me.ForeColor = 0
Me.Line (3.9 * 1440, 0)-(3.9 * 1440, 14400)
End Sub

Thanks again for your help and interest

Tim L-B