Results 1 to 10 of 10

Thread: Printing a Form

  1. #1
    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?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,448
    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 on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    970
    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.

  4. #4
    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?

  5. #5
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    970
    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.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,448
    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 on the Tiger 800 or the Norton

  7. #7
    Join Date
    Mar 2009
    Posts
    5,267
    - 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!

  8. #8
    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?

  9. #9
    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?

  10. #10
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,544
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •