Search

Web Development

General discussion

Gravatar
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.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| 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
3 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums