If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Printing a Form

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2009
Posts: 223
Printing a Form

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 coudl anyone direct me to which settings i shoudl change?

Thanks in advance.
__________________
What would you attempt to do if you knew you would not fail?
Reply With Quote
  #2 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,064
the clue is out there:-
use a report, for printing
use a form for viewing on screen

you can screen dump a form
but usually its best to design a report, then call that report form a button on your form and limit the items printed to the primary ke of the row you are displaying on the form

...so design the report
then add the report to the form using a command button using the control wizard to guide you through the steps to print the current record ONLY
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2006
Location: Surrey, UK
Posts: 965
Don't try to print a form. Forms are optimised for display on a VDU, not paper.
Design a report that uses the same data source as the form, and invoke that from a button on the form. You can pass it the key of the current record to control which record gets printed.
__________________
10% of magic is knowing something that no-one else does. The rest is misdirection.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Nov 2009
Posts: 223
Maybe I am lazy? But I can't see the benefit of designing and creating about 15 new Reports when the information and layout is completely acceptable in the Form format?

It is just unecessary extra work as far as I see it?
__________________
What would you attempt to do if you knew you would not fail?
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Sep 2006
Location: Surrey, UK
Posts: 965
Well, feel free to try. The rest of us will happily sit back and not try to force a square peg into a round hole :P
__________________
10% of magic is knowing something that no-one else does. The rest is misdirection.
Reply With Quote
  #6 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,064
so your options are
either to redesign your form so that it does fit your printer, and then get peed off becuase the form looks wierd on the screen
OR do some trickery that resizes all the controls, font sizes and so on on the fly so you can print the form
OR persuade your users to have a directly attached printer so that they can do a direct screen to print (not even certain this can be done on modern windowing systems. you used to be able in the good old days of W3.1

Access is a RAD tool, it makes assumptions and compromises to get most users woth a working system realitvely quickly. If you step out f the conventional Access world then you start having to do some heavyweight VBA development. Creating a report is a piece of pish. In my books its onme of the very very good reasons to use Access. the Report designer is excellent. Assuming you have defined your relations then all the 'parent' tabel details should be easy enough to draw through.


in short create a report.. its the Access way of doing things
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #7 (permalink)  
Old
Moderator
 
Join Date: Mar 2009
Posts: 5,123
- In Portrait orientation, an A4 page is 210mm (width) x 297mm (height).
- If you dont change the margins, the standard margins are set to 25.64mm or a little more than 1" (1" = 25.4mm), left, right, top and bottom.
- In Portrait orientation, this leaves a printable zone of 158.72mm (or 6.249") x 245.72mm (or 9.674").
- With rounding errors in the way, the exact dimensions that will exactly fit on an A4 size (Portrait) are: 8994 twips (Width) x 13928 twips (height)

Be aware that, by default, Access will print the form in continuous mode: if the form is bound to a data source and this data source has more than one row (record), the form with the information from the second row will be printed immediately after the form with the information from the first row, on the same page.

You'll need to find a mechanism to display only one record on each page. You can:
a) Apply a filter on the form so that it displays only one record,
OR
b) put a Page Break control on the form,
OR
c) Adjust the size of the form so that it fits exactly the printable zone of an A4 sheet (at least in height), as defined here above.

In Landscape orientation, you just swap the height and width, of course!
__________________
Have a nice day!
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Nov 2009
Posts: 223
thank you to everyone who has made comments on this post. it seems there are some very strong opinions to create a report instead of printing a form.

thanks for the suggestions on how to fumble through printing a form (even though it isn't recommended).

the information provided by you guys has been very useful (as always).

i will now continue with the creation of my database. cheers to all.
__________________
What would you attempt to do if you knew you would not fail?
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Nov 2009
Posts: 223
I learnt 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.

Thanks to Paul from BaldyWeb.
__________________
What would you attempt to do if you knew you would not fail?
Reply With Quote
  #10 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,475
Quote:
Originally Posted by reddevil1 View Post

...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.
Just so everyone knows, this has been available at least since version 2000. But I'm not sure that the tweaking needed will be any less than that needed to get the Form sized properly to print on one page. The advantage of using a Report, of course, is that so many Report-related functions are available.

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On