Search results

OK, seemed to come up with a solution, in case it's useful to others! Add this to the declaration at top of report code: Dim blnPreview As Boolean In the ReportHeader_Format section: If blnPreview Then ' Print preview mode Else iLine = 0 ' Print mode...

Ah. A bit of digging reveals that the iLine variable keeps on counting up after the report has print previewed. (So when printing the iLine starts at 37...... hence things getting messed up...) Don't know if I have enough knowledge to solve it, but I think that's the key....!

The example db that arnelgp posted does what we need display wise.... it fills the rest of the page with blank detail rows, which displays on screen in print preview mode fine. But when you come to actually print it, the blank rows aren't there anymore. In fact, with a bit more experimenting...

Hello Thanks for posting this example - it works great. But... I Just tried printing... and the blank lines don't print? They appear in the print preview (and not in report view, as you say) How do we get them to print? (They also don't appear on a PDF export...) Thanks once again! Chris