Share via

How to perform a page break in an Access FORM

Anonymous
2025-01-21T18:41:09+00:00

I'm working with a form created in Access by someone else. I can't not talk to him about it. I have connected 2 excel files: address list and donor activity. They appear to be in the proper format, using the same column names. The form prints all the information, but doesn't give a page break after each donor. It also only prints the FIRST contact name and address. I am running out of time to get the donor statements out on time. Does any one have any ideas why it wouldn't be performing a page break and printing the new address after each donor? Thanks

Microsoft 365 and Office | Access | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Accepted answer
  1. Anonymous
    2025-01-21T18:57:09+00:00

    Rather than trying to print a form, create a report which returns the same data as the form.  Report's include a sorting and grouping mechanism which you can use to present the data in a way appropriate to the printed page rather than to a screen.

    You might like to take a look at InvoicePDF.zip in my Dropbox public databases folder at:

    https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0

    This little demo file includes an option to return the current invoice in a form as a report.  It also includes options to output reports of multiple invoices as PDF files, either as separate reports or as a single report of multiple invoices.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-21T19:05:43+00:00

    Thank you so much for your reply. I did discover that the print preview solved all my problems and I have the page breaks where they belong. I am (obviously) very new at using Access and I didn't understand all the nuances in running the reports. I am going to take your advise on the other report I need to make. Again thanks!!

    0 comments