Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #9861
| From | Ulrich Möller <knobbi38@arcor.de> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Vertical lines in report |
| Date | 2014-09-03 18:07 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <lu7eb9$v0b$1@dont-email.me> (permalink) |
| References | <2923578b-b5c4-4acf-98f5-7afc8ae15f7c@googlegroups.com> |
Am 03.09.2014 um 16:23 schrieb Patrick Finucane: > I have a report in Access 2013. In the top part of the the form I have the fields for an order...the customer name, the order date, etc. In the detail section I have the list of items for the order. > > I want to place some vertical lines in the detail section of the report. Initially I drew the vertical lines 4.5 inches in height. I then placed a subreport in the detail section. This printed out the detail correctly but the subreport was on top of the vertical lines I had drawn and they did not display until after all of the line items were displayed. I attempted to send the subreport to the back but that didn't work. There was no option for setting the subreport to opaque or transparent. > > I then decided to link my main order query to the line item query. Then put the line item fields in the detail band. This didn't work so well. The detail section would print a detail line every 4.5 inches. If I shortened the detail section to the height of the detail lines that worked, but the vertical lines only went for 2 lines (as there were 2 line items in a sample test) and were cut off. The vertical lines were no longer 4.5 inches in height. > > How can I print my vertical lines? I want them to be 4.5 inches in height but the detail items can be however many there are in the section and may only be 1 inch in height. Any suggestions? > I use the report.line method in the detail_print event for this task. A detail descrition of the parameters and an example can be found in the help file. How the line will be drawn depends on some other report properties: ScaleMode, Draw..., FillStyle and so on. Ulrich
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread
Vertical lines in report Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-09-03 07:23 -0700 Re: Vertical lines in report Ulrich Möller <knobbi38@arcor.de> - 2014-09-03 18:07 +0200
csiph-web