lines that go across bands

[OhioSteve]

How do I draw a vertical line that starts in the page header band and ends in the detail band?

 

[dhookom]

Where do you want the line to end? In the top of the first detail record or the bottom of the last detail record? Can't you use a line control? If you tried this and it didn't work then you need to explain that you tried it and the reason it didn't work.

Duane
Hook'D on Access
MS Access MVP

 

[OhioSteve]

This is exactly what I did in the report designer:

1. I made the toolbox visible.
2. I single-clicked the line tool on the toolbox.
3. I moved my mouse over the page header band. The mouse pointer changed to an "x", indicating that it was ready to make a line.
4. I depressed and held the left mouse button. My line appeared.
5. While it was making my line, I moved the mouse into the detail band.
6. Access responded by making the page header band wider.

I want to change the behavior in step six. I want to make a line that starts in the page header band and continues into the detail band. This capability exists in Crystal Reports, and I need the same capability in Access.

 

[dhookom]

You can do this with a line control in the page header and a line control in the detail section. You can also use vba code in the On Format or On Print events of the sections to draw the line using no controls.

Duane
Hook'D on Access
MS Access MVP