Printing a Form

[reddevil1]

Yes, I do want the option to print a Form.

I am not able to find a resource which advises what width to design a Form so that it prints on standard A4 paper?

At the moment, my Form is 9" wide and it prints on 4 pages

Please could anyone direct me to which settings i should change?

Thanks in advance.

 

[YNWA]

Why not create a Report then use a command button to load the report ready to print?

 

[reddevil1]

That is because all the data is on the Form page already.

I can't see why I would need to create and design reports which would look identical to the Form?

This seems to be duplicated work?

 

[Alansidman]

I can't see why I would need to create and design reports which would look identical to the Form?

That is because forms were designed for data input and database manipulation. The architects never intended it to be printed. That is a spreadsheet mindset and not a relational database mindset.

Here is an idea that might work. Create a .PDF of your form. Use Snag-it or JING to create it. Import the .pdf into your report design. Then follow this video to have it populate correctly.

http://www.datapigtechnologies.com/flashfiles/pictureinreport.html

 

[reddevil1]

thanks for the suggestion, alan.

 

[davep56]

Standard size for a4 is 297 x 210 mm 11.7 x 8.3 in

So you could design your form to fit in that space. I think you need to leave a 3mm gutter margin to ensure it fits when printed

Another option to use a default form rather than creating a specific report is to ensure then you select print ( on my forms I have a print button on the top) and then when the print dialogue box appears see if you have a Fit to Size or Size paper by a %

Not perfect solutions but might help

Dave

 

[reddevil1]

thanks for your input, davep56

 

[Alansidman]

Just learned something new.

If you highlight the form in the navigation pane, then go to the file section of Access (Assuming you are using AC 2010), click on Save Object As, it will give you the opportunity to save your form as a report. You can then tweak as necessary.

Just found this out reading an old thread. Thanks to Paul from BaldyWeb.

Alan

 

[reddevil1]

Alan,

That tip is absolutely awesome. the report looks superb.

However, the report prints ALL the records and not just ONE record.

Otherwise it would be perfect.

 

[Alansidman]

You will have to put some VBA into your print command to only print one record. Look at the attached which specifies printing only the record that is open on the form.

 

[arichins]

I had a form in an ADP database that the user could print. It's a simple form which brings up rows in datasheet view. But I had to convert this form to accdb, and as part of that process, the source of the form was changed from a stored procedure to an ado query. The ado query usings commands that are specific to sql server. And when I actually to print it using Access Print preview button, it throws a syntax error on my query.

It's annoying that it can't just print what is on my screen. Why is it evaluating the VB code when I print preview? Why would it not work in print preview when it works on the form?