Force New Page using vba

[toptech]

Hi There.

My question is:

I am printing an Invoice on a pre-printed Invoice form that has many detail lines.

I have put in a line counter to count over the group.

I would like to force a new page after 14 lines of details.

Any info on this would be appreciated.

Thanks in advance.

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[Remou]

You can add a page-break control to the detail section and set its Visible property to 'No'. Set the Visible property to 'Yes' after 14 lines.

 

[dhookom]

The code in the On Format event of the section might look like:

Me.pagebreakctl.Visible = (Me.txtLineCounter Mod 14 = 0)

Duane
Hook'D on Access
MS Access MVP

 

[toptech]

Thnaks guys.

That should do it.


Regards,

Jeff



Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.