Is there any way to have a virtical line in a report automatically fill the page length?

Currently the column lines are in the detail section however there may up to three records on the form. With 3 records the lines run the full height of the report however with 1 or 2 they stop before reaching the footer.

Any ideas?

I did that once, and I don't recall needing code to do this. What I did was define the line as X long, then made that section (e.g. detail) that high, meaning that the line fits every record and will be that long.

I'm not sure if it's even possible to make a line run all across the paper as I don't remember Access having conception of pages. Could be wrong, though.

You can use the LINE method in VBA to put lines/rectangles on a page at Print time pretty much anywhere you want.
So the following will put a vertical line top to bottom on the left side of an A4 page e.g. in the On Page event:
me.LINE (0, 0)-(0, 13900)

Take a look here (http://msdn.microsoft.com/en-us/library/aa221362(office.11).aspx) for the syntax. Ignore the help that comes with VB as the syntax is nonsense!

hth
Chris

look at stephen lebans site for solutions to your problem