Help advancing a line (skip) without printing detail

[Paul7905]

Have a report that is going to be 3-hole punched and placed in binder.

I am looking for a way, based on number of detail lines printed, to skip printing a detail record and to leave a blank line at the vertical postion on the page so that when the paper is 3-hole punched, the data in the row is not punched out and made unreadable (I cannot format the report to avoid this, too much data with tight line spacing).

I figured that I could place a counter in each of the format
events to add to a counter and when I reach the line count corresponding to a hole punch, skip a line (refreshing the linecount to zero in the forms Page event)

Trouble is, I cannot figure out or find anywhere here in the forums a reference to skipping a line (printing nothing but not losing the current record)......... everyone seems to want to supress printing something but not printing a blank line (or skipping a line) before printing the detail.

Any help will be appreciated
Thanks!
Paul

 

[dhookom]

You could place an unbound text box at the very top or very bottom of the detail section. Make it very short so it doesn't normally effect any part of the detail section. Then, assuming you have a variable or code that determines it's location on the page, set the text box control source to several carriage returns thus making this section taller with some blank space.

If somevariable = expression then
Me.txtBlank = Chr(13) & Chr(10) & Chr(13) & Chr(10)
Else
Me.txtBlank = Null
End IF

Duane
MS Access MVP

 

[RickSpr]

Look up the topic "MoveLayout, NextRecord, and PrintSection Properties" in the help file. These are properties of the Report object that you can set in the Print event. You can count details and, when you want to skip a detail section, set PrintSection and NextRecord to False to avoid printing anything or moving to the next record.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Paul7905]

Thank you Gentlemen !

I tried both options and each worked great !

Rick, thanks for teaching me something else, namely, investigating the properties of an object.......(I had not considered this at all (was not aware of this or how to do it actually)).

Paul