Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » database+courses+london - Printing

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

database+courses+london - Printing

Resolved · Low Priority · Version Standard

Reply Thu 25 Oct 2007, 17:45Delegate Sabine said...

Sabine has attended:
Access Intermediate course

Printing

for some reason when i want to print a report, i have a blank page between each report. How can i remove this blank page?

For upcoming training course dates see: Pricing & availability

Reply Tue 30 Oct 2007, 10:06Trainer Richard said...

RE: printing

Hi Sabine

Thanks for your question. It could be a number of things, but lets check the basics first.

With Access reports, what can happen is that if the report area is wider than the page it is on, even if there is no fields or data showing in that area, then it will go on to print a blank page.

So What you need to do is to either:

1. Rerun your Report wizard, and make sure you tick the box that says "Fit all fields onto one page". This will ensure that you do not go onto another page to the right of your fields.

2. The other option is to MANUALLY shift your fields to the left, and then drag the background area from the right edge in the LEFT direction. You may need to make some changes and them check and see if it has worked.

There are other settings that allow you to put in blank page. It is unlikely that this is the case unless you have changes the FORCE NEW PAGE setting in the properties for the DETAIL section.

Hope that helps, and let me know if you manage to get it sorted out. Fell free to post any further questions about reports or using Access as you progress in building your database.

Kind regards

Richard
Microsoft Office Specialist

Access articles

· What Is The Database Documenter And How Is It Used?
· Access Corruption Avoidance Tip #1: Split Your Database
· How Microsoft Access grows with your company
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.

View all Access hints and tips