I have a report that has 2 lines in the details band, each is bordered by vertical lines. The vertical lines on line 2 are dependant on there being a value to display in the textbox on that line.

My problem is that when calculating if the next details band will fit on the page, Foxpro counts both lines, so if the don't fit it throws a page. This is not a problem EXCEPT: my vertical lines do not then meet the footer as the lines on "line 2" do not print if the textbox is empty.

I think I need someway to know that a page break is being thrown BeforePageBreak(), OnPageBreak(), sort of thing so that I can print the line conditionally. I have tried the OnEntry and OnExit of the headers and footers but neither works at the right time. I have a variable I can set, but can't find anywhere to set it from.

Does my explanation make sense? Any ideas?


Gary.