Print Form

[Parra]

I am sure that there is a way to do this...Print the form to fit on 1 page, and only the current record.

Thanks

Parra

 

[Parra]

Kind of like the "Fit To 1 Page" option in Excel.

Parra

 

[Joe4]

On the Header/Footer section properties, you can set the Force New Page properties so that you only have one record per page (you may have to use grouping, too).

However, I do not believe Access has any "fit to one page" or "scalable" otpions like Excel does. The report writer behaves more like Word than Excel, in this respect, where you have a defined page size you are working with.

 

[SydneyGeek]

My 2 cents...

Forms are not really designed for printing -- that's the job of a report. I'd recommend building a report on the same recordset as the form, and having a button on the form which opens the report with just the current record displayed (the Wizard will set this up for you if you create the button with Wizard enabled).

Advantages:
1. You can lay out the report however you like.
2. You can have exactly the same fields as the form, or more or less, depending on requirements.
3. You will ensure that only 1 record is there, so you will print on one page only.
4. If you change your mind, you can print multiple records in the report -- still one to a page -- by performing a Find and opening the report with all of the same records.
5. You'll use a hell of a lot less toner / ink...

Denis