Web Development

General discussion

Gravatar
0 Votes
Locked

Access 97 Report Lines Per page

By MRA2 ·
I have a report which must have only 15 lines or less per page. When there are more than 15 lines a page break occurs. Someone gave me this code a while ago:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Text15 Mod 15 = 0 Then
Reports![Employer contribution Report].Section(acDetail).ForceNewPage = 1
Else
Reports![Employer contribution Report].Section(acDetail).ForceNewPage = 0
End If
End Sub

If works well EXCEPT when there are exactly 30 records. It prints a blank page first, then the data...

Can you help???


Thanks!!!!!!!!!!!!!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Access 97 Report Lines Per page

by john_wills In reply to Access 97 Report Lines ...

I believe that you will get a blank page first when you have exactly 15, exactly 45 or exactly any other multiple of 15 records. I do not know just what you have in text15, nor just how you invoke the procedure, but I am sure that choosing the rightexpression in the modular condition will give you what you want.

gravatar
Collapse -

Access 97 Report Lines Per page

by MRA2 In reply to Access 97 Report Lines ...

Thanks for your help.....

gravatar
Collapse -

Access 97 Report Lines Per page

by MRA2 In reply to Access 97 Report Lines ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums